View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chatterbox chatterbox is offline
external usenet poster
 
Posts: 11
Default Handling Worksheet Events of a Worksheet Created During Runtime.

Hi Everyone.

I have a small program which creates a worksheet at runtime to display
the results of its analysis in the active workbook. I wish to use
either the worksheet SelectionChange or BeforeRightClick event to
respond to the user interacting with a specific section of the results
worksheet.

If the results worksheet is created at runtime, can anyone tell me how
I should code the user interaction worksheet event ?

If I must create some kind of dynamic worksheet event handler class,
are there examples out there ? Or is the proper solution more obvious
than that ?

Thanks in advance

Chatterbox