Clicking(ONLY) a table cell to initiate actions

[bowlesj]

Hi,

With the help of Google searches I managed to get Excel VBA code working that causes my clicking on an Excel cell in a rows/columns table to initiate one or more actions that update other cells in the same row or even the clicked cell of that row. However moving the cursor into this cell from any direction with any keyboard keys (arrows, tab, shift+tab) also triggers the very same actions. So it appears that what I tried was in fact being executed by the "got focus" or "on enter" function as we MS-Access programmers would call it. I did several google searches and found no way to limit the action to a click as us Access programmers often do in a table with "On Click".

Does anyone know if Excel can initiate actions "On Click" only and where/how I might find examples?

Thanks,
John

 

[Michael M]

Might be worth reading......

Mouse click event

How can I write a mouse click event in the Worksheet_SelectionChange sub? I want to execute a procedure only if user clicks the cell. Right now everytime i move the cursor, the Worksheet_SelectionChange gets triggered. Thanks.

www.mrexcel.com

 

[bowlesj]

Might be worth reading......

Mouse click event

How can I write a mouse click event in the Worksheet_SelectionChange sub? I want to execute a procedure only if user clicks the cell. Right now everytime i move the cursor, the Worksheet_SelectionChange gets triggered. Thanks.

www.mrexcel.com

Thanks for such a speedy reply Michael M. I will read it now. John.