Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can a Combobox in a Userform access multiple dynamic tables | Excel Discussion (Misc queries) | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) |