VBA: Userform Access
 

I created a Userform in my workbook, let's call it MyForm.

Whenever I try to access it, I get an "Type Mismatch"
error. For example, If I try to do something as simple
as:

Userforms("MyForm").Show

or

Userforms("MyForm").ComboBox1.Value = "whatever"

Please help.

Userform Access
 

Shon,

If the name of the form is "MyForm" (as seen in the project window) or as
seen in the Properties Window under (Name)
than all you need is
MyForm.Show
or
x = MyForm.ComboBox1.Value

--
sb
"Shon Yim" wrote in message
...
I created a Userform in my workbook, let's call it MyForm.

Whenever I try to access it, I get an "Type Mismatch"
error. For example, If I try to do something as simple
as:

Userforms("MyForm").Show

or

Userforms("MyForm").ComboBox1.Value = "whatever"

Please help.