VBA: Userform Access

  • Thread starter Thread starter Shon Yim
  • Start date Start date
S

Shon Yim

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.
 
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
 
Back
Top