Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a user form that I'd like to establish a global constant, but I
don't know how. I've tried: Public Const strPW As String = "myPW" but it errors out saying that this is "not allowed as Public members of object modules". Can I declare this publicly so that I don't have to do it in every subroutine? Thanks, Randy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Global (Module) Variable Problem | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Create Global Variables in a module | Excel Programming | |||
Global module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |