fire an event; SelectionChange

[cate]

I have a command button that updates cells but somehow escapes
triggering the sheet's SelectionChange. It there a way I can hit this
in VBA?

 

[Gord Dibben]

SelectionChange event is triggered by cell selection, not by changing the
value in cells.

Maybe you need Worksheet_Calculate event.


Gord Dibben MS Excel MVP

 

[cate]

SelectionChange event is triggered by cell selection, not by changing the
value in cells.

Maybe you need Worksheet_Calculate event.

Gord Dibben  MS Excel MVP

Ahh, yes, that works. Thank you.