Set Global Variable Inside Object Module

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

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
 
You can remove Public and it will work and still be recognized inside private
subs in your userform.
 
If you want to access it beyond the userform, you can either set it up as a
Public Const in a standard code module rather than the userform, or you
could create a public property of the userform and load it in the form
initialize event.



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top