View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NOPIK NOPIK is offline
external usenet poster
 
Posts: 50
Default How to reach Application Objects in Events?

Need to perform Range("A:A").Find operation in
ActiveSheet.Button1.OnClick event handler in module (not in a class!).
Button - member of the sheet. But, Application members seems to be
not visible for events until they specially declared (if I call event
handler as procedure it works).
Is there any common way to get any objects, visible in ordinal modules?