Constant Variables

[austin350s10]

Ok ...so I have a userForm (Form1) that contains a persons name that I would like to reference in a separate UserForm (Form2). In the separate UserForm (Form2) I need to reference this persons name many times, so I was wondering if there was a was to declare this name in the separate UserForm (Form2) as a constant. Only thing is that a constant, to the best of my knowledge, must be an expression and not a variable. Mainly, I'm trying to avoid declaring the myName variable in each Sub within Form2, which it will be needed for a ton of Sub's. Any ideas would be appreciated.

This is what I'm tying to do, but wondering if there is a better way to do this??

code for Form2:

Const myName As String = Form1.txtName.Value

 

[JLGWhiz]

Ok ...so I have a userForm (Form1) that contains a persons name that I would like to reference in a separate UserForm (Form2). In the separate UserForm (Form2) I need to reference this persons name many times, so I was wondering if there was a was to declare this name in the separate UserForm (Form2) as a constant. Only thing is that a constant, to the best of my knowledge, must be an expression and not a variable. Mainly, I'm trying to avoid declaring the myName variable in each Sub within Form2, which it will be needed for a ton of Sub's. Any ideas would be appreciated.

This is what I'm tying to do, but wondering if there is a better way to do this??

code for Form2:

Const myName As String = Form1.txtName.Value

Does it not work as:

Public myName As String

placed in the public (standard) code module1?

 

[austin350s10]

Yeah, That works but it just declares the variable. I wasn't able to figure out a way to set it once like you can with a constant. Is there a way to set a variable once and reuse it in multiple sub's?

 

[vw412]

The UserForm is simply a special Class that is predefined by VBA. You can add properties and methods to this Class and extend it. Search for UserForm as Class or Object and see if you don't find ways to do what you want.

I personally would declare the myName as a Property in the UserForm and then set its value from the main calling procedure before displaying the form.

 

[austin350s10]

Nevermind...I figured out what you mean. Set the variable up top and assign the variable with UserForm_Initialize()

Thanks!!

 

[JLGWhiz]

Nevermind...I figured out what you mean. Set the variable up top and assign the variable with UserForm_Initialize()

Thanks!!

You got it!

Regards, JLG