Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Public variables shouldn't get lost unless you do something in the code (or via
the VBE user interface) to reset them. Gary Brown wrote: I THINK that the global variables work between modules but I THINK they get 'lost' when switching bwetween forms and modules. So to be safe, I write the date to the registry then pull it out when I need it and not worry about scope. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "musclpete" wrote: So there's no way to create a global var and 'pass' between forms? Is that why you have to use the registry? Or is it just something funky with the calendar control? "Gary Brown" wrote: 1) Create a separate form called 'UFCalendar' 2) Put the active X calendar control on it. 3) Name the calendar control 'AXCalendar' 4) put the following code in the UFCalendar form - double-clicking will cause date to be stored -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Form with Calendar Control - Excel 2002 to 2003 compatibility | Excel Programming | |||
calendar control excle 2003 | Excel Worksheet Functions | |||
Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
Backwards compatibility with Excel 2003 Calendar Control | Excel Programming | |||
calendar control xls 2003 | Excel Programming |