Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Location; sheet, workbook, module
I'm new to VB. Does it matter whether I put my VB code in the sheet, workbook
or modules on the VB window? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Location; sheet, workbook, module
It sure does. You might want to consider taking Lesson1 of Excel VBA
Training at http://www.vbaexpress.com/training/ In a nutshell: Put it in a module if you're unsure. Anything that you want to occur on a specific worksheet as a result of a specific action, put in the worksheet code. Anything that you want to occur in the workbook, such as before you close it or save it or when you open it, then the code should go in ThisWorkbook. Well, there's class modules too. I know Chip Pearson has some good info about it. Though it says Excel 97, things haven't changed a whole heckuva lot: http://www.cpearson.com/excel/events.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "James Hamilton" wrote in message ... I'm new to VB. Does it matter whether I put my VB code in the sheet, workbook or modules on the VB window? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Location; sheet, workbook, module
Many thanks Anne.
"Anne Troy" wrote: It sure does. You might want to consider taking Lesson1 of Excel VBA Training at http://www.vbaexpress.com/training/ In a nutshell: Put it in a module if you're unsure. Anything that you want to occur on a specific worksheet as a result of a specific action, put in the worksheet code. Anything that you want to occur in the workbook, such as before you close it or save it or when you open it, then the code should go in ThisWorkbook. Well, there's class modules too. I know Chip Pearson has some good info about it. Though it says Excel 97, things haven't changed a whole heckuva lot: http://www.cpearson.com/excel/events.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "James Hamilton" wrote in message ... I'm new to VB. Does it matter whether I put my VB code in the sheet, workbook or modules on the VB window? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Code Module: copying code to | Excel Programming | |||
Sheet code module question | Excel Programming | |||
Adding Code to the This_workbook module of a created workbook | Excel Programming | |||
Write VBA code into a sheet module using VBA | Excel Programming | |||
Adding Code Module to Workbook | Excel Programming |