Detecting worksheet change from modeless userform
 

Hello all,

I am writing an add-in with a userform that needs to detect when a
change occurs (by the user) on the active worksheet. The
Worksheet_Change event would work if I was coding in a workbook only,
but the userform can't depend on any code in the worksheet/workbook.


Thanks in advance,

-Kent

Detecting worksheet change from modeless userform
 

I could really use some help with this... anybody... please?

Kent wrote:
Hello all,

I am writing an add-in with a userform that needs to detect when a
change occurs (by the user) on the active worksheet. The
Worksheet_Change event would work if I was coding in a workbook only,
but the userform can't depend on any code in the worksheet/workbook.


Thanks in advance,

-Kent