View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default 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.