fire an event; SelectionChange
 

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?

fire an event; SelectionChange
 

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

On Sat, 12 Dec 2009 15:36:30 -0800 (PST), cate
wrote:

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?

fire an event; SelectionChange
 

On Dec 12, 5:45*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Sat, 12 Dec 2009 15:36:30 -0800 (PST), cate
wrote:

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?

Ahh, yes, that works. Thank you.