Following macros from the Modules

[ehome.ptmacky]

Hi all, I am new with VBA and im still learning lots of things. Is there a way for me to know which particular sheets/command buttons/cells is the module assigned to? I have a file that has macro and I am trying to follow through the modules' codes but couldn't really understand.

[jeffreybrown]

For command buttons, right click on the button and select assign macro. In the dialogue box at the top you will see what macro is activated.

For sheets, right click on the sheet tab and select view code. Within the sheet code, you may see some Call's to other VBA scripts. Highlight the name of the Call and select Shift + F2 which will take you to the code.

Hope this helps...

[ehome.ptmacky]

Hi Jeff, thank you so much. Exactly what Im asking for. Last question though, so if i select the View Code option and am directed to the VBE and dont see anything written on the screen, then it means that there are no Macros assigned to that particular sheet?

[jeffreybrown]

Correct, but also while your in the VBE, look at the tree on the left side of the screen and now you can work through all the worksheets and any modules.

[ehome.ptmacky]

thank you so much! much appreciated help

[jeffreybrown]

You are very welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.