How to pass a parameter to a userform

[Gromit]

Hi,

I need to both open a useform and pass a parameter to it. How do I do
this? I'd like to do the following but the Show method doesn't take
this kind of parameter.

Userform1.Show(param)

Cheers

Gromit

 

[Bob Phillips]

Create a public variable in the userform, say called myVar, and then

Load Userform1
Userform1.myVar = "SomeValue"
Userform1.Show


and then use myVar in the form

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gromit]

Thanks Bo