Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error on form show
Hi
I am experiencing a problem for some users for a macro-enabled spreadsheet I have developed. The users are using Office XP, I have developed the spreadsheet in Office 2003, but it has worked on Office XP without any problems until now. They are getting the error message 'Type Mismatch -2147352571' when they click a button on one of the sheets. The code behind the button is just calling a form.show event. I am at a loss to explain why this is occurring. Can any one help? Thanks Darach |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error on form show
No real answer, just speculation and a line of reasoning to check:
Since you state "form.show" and not Userform.show, I am thinking perhaps you are not using a standard userform here? If there are conflicting object class names (as, for example, having an MSForms Form object in the same project as an Access Form object) and you do not specify (e.g. Dim MyForm as Form) VBA follows the order listed in References to determine which one takes precedence. And I have had upgrades to Office on my computer that have modified the references in my projects without me "doing anything." So I would suggest checking the references to see if there might be conflicts between form objects in the different libraries listed. The best solution is to explicitly reference the object (Dim MyForm as Access.Form, for example). If this isn't it, it would help to see the code - especially the line where the error occurs and also (if you are using a variable for the form object) how you have Dim'ed the object variables. -- - K Dales "Darach" wrote: Hi I am experiencing a problem for some users for a macro-enabled spreadsheet I have developed. The users are using Office XP, I have developed the spreadsheet in Office 2003, but it has worked on Office XP without any problems until now. They are getting the error message 'Type Mismatch -2147352571' when they click a button on one of the sheets. The code behind the button is just calling a form.show event. I am at a loss to explain why this is occurring. Can any one help? Thanks Darach |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
#13 type mismatch error on user form for Dave Peterson | Excel Discussion (Misc queries) | |||
Type Mismatch error | Excel Programming | |||
Help with odd type mismatch error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |