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?
|