chrisjames25
Registered User.
- Local time
- Today, 08:26
- Joined
- Dec 1, 2014
- Messages
- 401
Hi
NIce and simple one for the forum i think.
If i want to declare some variables that i can then reference within the whole vba code for a particular form how do i do it?
At moment i am doing
However it is not defining the variable for me.
I get very confused with naming conventions, but i want these to be available for the whole of a form but not be used outside the form so do they need to be public or can then be private. If private how do i define them so not associated with only one event of the form.
NIce and simple one for the forum i think.
If i want to declare some variables that i can then reference within the whole vba code for a particular form how do i do it?
At moment i am doing
Code:
Public StrTier1, StrTier11 As String
StrTier1 = "Category"
StrTier11 = "category"
However it is not defining the variable for me.
I get very confused with naming conventions, but i want these to be available for the whole of a form but not be used outside the form so do they need to be public or can then be private. If private how do i define them so not associated with only one event of the form.