how to know, in wich part of excel file have vba code?

[jamiguel77]

hi all, i open a excel file with vba code.

the question is simple, how to know where exist the vba code?

not i know how to write vba code..

but in wich part ?

Image — Postimages

postimg.cc

thanks

 

[mumps]

Usually code can exist in regular code modules, worksheet code modules and workbook code modules. In the image you posted, double click on the sheet names (Hoja1, Hoja2, etc.), the regular modules (Modulo1, Modulo2, etc.) and ThisWorkbook. When you double click on any of these, any existing code will be visible. If the pop up windows are blank, there is no code in that module.

 

[6StringJazzer]

Your image shows that you can already access the VBA code. Double click on a module to see the code in that module.

6StringJazzer on: How To Install VBA Code

 

[jamiguel77]

yes... i can check all module parts
but only in this Modules.... can write VBA code or any other place?

Thanks

 

[mumps]

Where you place the code depends on what you are trying to accomplish.

 

[jamiguel77]

Yes i understand, but i have a work to do (this file i dont created) and is examine/explore all the file, know what to do, step by step.

if exist any keydown methods, any load methods, any button click, and etc etc....

understand me?

thanks

 

[mumps]

I'm sorry but I don't understand what you are looking for. If you are looking for a macro to perform a task, then you will have to give me more information. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do, step by step, referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).