Software

Ask something
Discussion Locked

Excel mouse data entry

0 helpful
3 replies

by baileyp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to know how to add 1 to an excel cell with the left click of the mouse button and have this set so that 1 gets added to the cell for every click on the mouse. Can this be over-ridden by keyboard entries?

3 replies

by p7ants

1) In the VBA editor (I press ALT-F11) select a Sheet in the Project window by dbl-clicking.

2) Select the Worksheet object in the object dropdown (it probably is currently displaying "(General}").

3)Select Worksheet_Change in the Properties dropdown (it probably is currently displaying "(Declarations}")

4) Insert this: Target.Value = "5"

5) close the VBA editor.

by baileyp

Answer added 5 to every cell that was clicked on or passed over using arrow keys. Didnt help but a step in the right direction, thanks.

This discussion is closed to new replies.