ExcelBanter - Event on a cell click

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Event on a cell click (https://www.excelbanter.com/excel-programming/377583-event-cell-click.html)

Jac Tremblay[_4_]

Event on a cell click

Hi,
I would like to know if it is possible to trigger an event when someone
clicks on a cell or its content.
I've seen lots of events possible, like SheetActivate or WorkbookOpen, but
can't find a cell click event.
Thanks
--
Jac Tremblay

NickHK

Event on a cell click

Jac,
Check out the Worksheet_SelectionChange and/or Worksheet_Change events.

NickHK

"Jac Tremblay" wrote in message
...
Hi,
I would like to know if it is possible to trigger an event when someone
clicks on a cell or its content.
I've seen lots of events possible, like SheetActivate or WorkbookOpen, but
can't find a cell click event.
Thanks
--
Jac Tremblay

Jac Tremblay[_4_]

Event on a cell click

Hi NicKHK,
Thanks for your answer. I will do that for sure. I have seen something
similar but cannot remember where nor when.
Thanks and have a good day.
--
Jac Tremblay

"NickHK" wrote:

Jac,
Check out the Worksheet_SelectionChange and/or Worksheet_Change events.

NickHK

"Jac Tremblay" wrote in message
...
Hi,
I would like to know if it is possible to trigger an event when someone
clicks on a cell or its content.
I've seen lots of events possible, like SheetActivate or WorkbookOpen, but
can't find a cell click event.
Thanks
--
Jac Tremblay

All times are GMT +1. The time now is 03:36 PM.