I have a sheet a lot of buttons and a lot of macros. I've lost sight of which button is connected to which macro. How do I check that?
I have a sheet a lot of buttons and a lot of macros. I've lost sight of which button is connected to which macro. How do I check that?
Hi,
If you right-click a button and choose Assign Macro, it will show you the name of the currently assigned macro. I would also recommend changing the button captions and macro names to make the link clearer- a naming convention will go a long way towards this.
Don
Please remember to mark your thread 'Solved' when appropriate.
Try this:
Please Login or Register to view this content.
Hello ikboy
I think using this line
is more general with form buttons and shapes ...Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi YasserKhalil
I completely agree with your
Thanks a lot Mr. ikboy
I have command button activex control and I could get the caption .. but what about onAction for this command button?
ActiveX controls do not have macros assigned to them. They have event code. Such code will always include the name of the control and must be in the code module of the self same sheet, and is thus fairly easy to locate. Indeed, within the VB Editor, selecting the control from the leftmost dropdown (above the main code window) will indicate which, if any, events are in use in the rightmost dropdown. The items in bold are in use.
Thanks again and again Mr. xlnitwit for illustrations and great help
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks