-
Add a parameter to your macro that holds the control or the control's name (depending on what you want to use it for). Then in each place that you call the macro you need to add the parameter that identifies the control.
If you want to be able to call it when you don't care where it's from then make the parameter optional.
To help more specifically I'd need to know why you need to know where the macro is called from, what are you going to do with this information?
K
Software Matters - VBA Programmers - Straightforward Solutions To Take Care Of Your Business
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules