Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When to code in sheet or userform modules and when to use modules
Hi
I am beginning to appreciate what I can do with excel and vb but I am trying to develop some rules for myself regarding when to put the code in a modue and when to put it behind the userform sheet etc. does anyone have some rules? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When to code in sheet or userform modules and when to use modules
Tony,
If the code is only to be used by that form, you can put it in the userform module. If it is to be used elsewhere, including another form, make it public and put it in a general module. -- HTH RP (remove nothere from the email address if mailing direct) "Tony James" wrote in message ... Hi I am beginning to appreciate what I can do with excel and vb but I am trying to develop some rules for myself regarding when to put the code in a modue and when to put it behind the userform sheet etc. does anyone have some rules? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where 2 place the code? (Worksheet Codes Vs. Modules) | Excel Discussion (Misc queries) | |||
Delete Code Modules Programatically | Excel Discussion (Misc queries) | |||
editing code in modules through VB | Excel Programming | |||
Class Modules vs Modules | Excel Programming | |||
Using the same variable in separate userform modules | Excel Programming |