How to find the VBA code of a button without clicking it??

[techcrium]

I received a excel file and it has all these buttons and codes. How do I quickly find out which VBA code a button is linked to without clicking it?

When I click this button, the code that runs hangs this program so I have to Ctrl Alt Delete to kill it.

I can't right click or anything.

[arlu1201]

Your post does not comply with Rule 6 of our Forum RULES. Common courtesy is the order of the day. Avoid coarse language, provide feedback to suggested solutions, and take the time to thank those who took their time to help you.

Coming back to your question. Press Alt+F11 on your file. It will take you to a code window. You should find some code headers like commandbutton1_click() or something which will tell you its the code for that button.

If not, then just attach the file after removing all sensitive data and we can help you out.

[techcrium]

ok thanks for the reply.

Now, what if the VBA code window has 5000 functions? There are headers like commandbutton534_click().

Do I do through them all and put a msgbox("hi you clicked me on button XXX") in each of them, 5000 times?

[Norie]

You can right click a button and either select View code (ActiveX) or Assign Macro... (Forms) to find the code associated with the button.

It sounds like you might be dealing with quite a few so it might be worth watching out for any sort of pattern in the code.

[g8r777]

It depends on what type of buttons you have.

If you have a Form Control button then right-click on the button and select "Assign Macro". You should see a box at the top that says "Macro Name". In that box you should see something that looks like this "Book1!Sheet1.Test2Button". The portion Book1 just tells you the name of the workbook (Excel file) that the macro is in. !Sheet1 tells you that the macro is in the sheet module for the sheet named Sheet1. Your button may not have that portion if the macro is in a standard module. The actual name of the sub that runs when the button is select is Test2Button. You can pull up the VBA editor using Arlette's instructions above and do a search for that macro name to find it.

If you have an ActiveX control button instead the easiest way to find the code is to enter Design Mode. You can find this under the developer tab at the top of the screen. If you don't see the Developer tab you need to activate it by going to File --> Options --> Customize Ribbon and then checking the box in the right window next to Developer. Once in Design Mode, simply double-click on the button. The VBA editor should pop up and you should be in a sub that looks something like this:

Please Login or Register  to view this content.

[techcrium]

It depends on what type of buttons you have.

If you have a Form Control button then right-click on the button and select "Assign Macro". You should see a box at the top that says "Macro Name". In that box you should see something that looks like this "Book1!Sheet1.Test2Button". The portion Book1 just tells you the name of the workbook (Excel file) that the macro is in. !Sheet1 tells you that the macro is in the sheet module for the sheet named Sheet1. Your button may not have that portion if the macro is in a standard module. The actual name of the sub that runs when the button is select is Test2Button. You can pull up the VBA editor using Arlette's instructions above and do a search for that macro name to find it.

If you have an ActiveX control button instead the easiest way to find the code is to enter Design Mode. You can find this under the developer tab at the top of the screen. If you don't see the Developer tab you need to activate it by going to File --> Options --> Customize Ribbon and then checking the box in the right window next to Developer. Once in Design Mode, simply double-click on the button. The VBA editor should pop up and you should be in a sub that looks something like this:

Please Login or Register  to view this content.

Oh ok, design mode is the key.

Thanks.