Worksheet Deactivate

[shsassy]

Hello all,

I have an issue and I am not really sure where to start. What I need to do is check the value of a cell after the user has clicked off of it. I am guessing that this would be done on the worksheet's deactivate event. Anyone have any idea what to do? Also the cell I need to check is merged. It is cell F15:G15.

Thanks

[royUK]

The first thing is to avoid Merged Cells, they will always complicate matters. The deactivate_event will occur when the sheet is exited by selecting another sheet. maybe you need the Worksheet_Change event. Something like

Please Login or Register  to view this content.

[shsassy]

Thanks so much Roy, that is just what I was looking for.

Appreciate it!

:P

[royUK]

Glad it helped.