Donde colocar codigo VBA?

Hello

I hope you can understand English.

Sheets:
You can code VBA in the sheets for a few different purposes.
1. You are coding objects that are located in sheets (e.g. command button, combobox etc.).
2. You want to use sheet events. There are many sheet events, but as an example you may wish for a macro to run eveytime someone changes something on a sheet. Example, place this code in one of your sheets. Then go back to your sheet and notice how everytime you select A1 it will trigger the macro:


ThisWorkbook:
Again this is often used for event driven macro's. Let's say you want a macro to run each time the workbook is opened. Then you would use the Workbook_Open event. Example, place this code in Thisworkbook, save the file, close it and then open the file. It will trigger the macro everytime you open the workbook:


Module:
Notice that if you record a macro that the code is stored in a module. This is because you are expected to trigger the macro directly. You can, however, assign a sub routine to a object like a command button without coding the button directly. Modules are also useful for storing functions. The functions can be used like a worksheet function (e.g. SUMIF) but they can also be called in other routines.

I recommend you buy a good book. I can recommend some but I don't know if any are available in Spanish:
Excel 2003 (or 2007) Power Programming in VBA by John Walkenbach
Possibly this from MrExcel: http://www.mrexcel.com/sunshop/index.php?action=item&substart=0&id=50

Hopefully one of our Spanish speaking members will pop in soon and give you more information in Spanish, and perhaps they can recommend some good Spanish web site for VBA and Spanish books.

Hola Sam,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Por lo general un pone código VBA en módulos normales. Uno coloca código en módulos de hojas y cuadernos cuando uno necesita reaccionar a ciertas acciones tomadas por el usuario.
<o></o>
En Object Oriented Programming, (programación orientado a objetos) cuando el usuario hace algo a un objeto, puede ser que el objeto levanta un evento (raises an event). Lo módulos de hojas y cuadernos que usted ve en al VBE son una especie de Class Modules. Uno usa class modules para programar “event handlers”.
<o></o>
En el caso de hojas y cuadernos, dado que cuadernos son padres de hojas, hay dos lugares para manejo de eventos de hojas. Uno dentro de la hoja misma que corresponderá únicamente a eventos de tal hoja y también en el cuaderno que tiene un “handler” para tal evento pero para todas las hojas. Además, dentro del class module del cuaderno se puede responder a eventos que el cuaderno levanta pero no las hojas, como OPEN, BEFORECLOSE, BEFORESAVE, etc. <o></o>
Atte, <o></o>

Gracias and thanks to Greg and Jon for the great input. I've been reading off the web about the subject but will definately buy a book to learn lots more!