General discussion


Excel: Update No. with a Click

By dvillanueva ·
Is it possible in Excel to simply "click" in a cell and have the number update; i.e., first click would be number "1" -- click again and it updates to "2", etc.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Excel: Update No. with a ...

i don't see any way to attach code to an 'on click' event in a cell...would it work if user clicked 'button', not cell?

Collapse -

by DKlippert In reply to Excel: Update No. with a ...

No you can't do it
Yes you can.
John Walkenbach and Malcolm McKinnon have an interesting approach. They create a transparent square over the cell that invokes a macro.

Related Discussions

Related Forums