User Form variables 1

[BlueMonkey]

Hi

Short and sweet - What's the best way of getting the results of a UserForm back to the calling procedure.

At present I can't get them back to the calling procedure (which I want to do for tidyness) - I have to call another procedure from the form's closing code.

Thanks in advance

B.M.

 

[combo]

You can define public values in a standard module and change them in UserForm module.

Another option - hide userform, read its settings and unload it. Having userform1 with checkbox1 and commandbutton1 and code:
[tt]Private Sub CommandButton1_Click()
Me.Hide
End Sub[/tt]
and standard module with:
[tt]Sub GetUFValue()
UserForm1.Show
MsgBox UserForm1.CheckBox1.Value
Unload UserForm1
End Sub[/tt]
you get setting of checkbox.

combo

 

[BlueMonkey]

What's the syntax for the public variable option?

B.M.

 

[combo]

For DoubleVarName variable declared as Double type:

Public DoubleVarName As Double

combo

 

[BlueMonkey]

I get "invalid attribute in Sub or Function" when I try that - am I trying to put it in the wrong place???

B.M.

 

[combo]

The variable should be declared at the module level in declarations section, i.e. outside and before any procedure.

combo

 

[BlueMonkey]

Thanks combo, I just worked that out as you were typing.

Cheers

B.M.