View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_113_] Mike[_113_] is offline
external usenet poster
 
Posts: 40
Default Trigger an Excel VBA event from another application

I can send a message to a dotNet Textbox and have it trigger the
TextBox_Change event. What I want to do is the reverse. I want to send a
message from dotNet to Excel VBA and have it trigger some event so I can
immediately respond to the event. Since I can't get a Handle for any of the
VBA controls, I'm not having much luck. I can send a message that changes
the Form Caption but this doesn't trigger any event that I can find, and I
want to stay away from a polling technique.

Any ideas would be appreciated.

mike