Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When you have a large application with lots of modules and forms and a large
number of public variables what would be the best way to organize and reduce these public variables? Making all these variables private or local is not an option as it would mean an enormous duplication of code. The 2 options I can see are making classes or UDT's and maybe UDT's are the simplest option. So with a UDT I would get a public type with a number of elements that are the old public variables. Then there would be a public variable declared as this public type. Would this make sense or are there any better options? RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
public variables | Excel Discussion (Misc queries) | |||
Public variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Programming | |||
Public Variables | Excel Programming |