VBA Setting value error

[moglione1]

Hi All,

I have a major problem with a macro I built: It cant load forms.

THe user should be able to select an option from the dropdown list and
then be presented with a form but I get the following error:

Error Des: Could not set the value property. Type Mismatch
Error ID: 2147352571
Error source: Forms.Textbox.1

Can somebody please enlighten me to why this is happening and if there
is a fix - I am at a loss becuase I cannot replicate this user error.


+-------------------------------------------------------------------+
|Filename: VBAError.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4804 |
+-------------------------------------------------------------------+

 

[Ivan Raiminius]

Hi,

have no idea if applicable in your case, but in similar situation
helped me to export all the modules and import them into a new
workbook.

Regards,
Ivan

 

[broro183]

Hi,
Just did a quick google for your error # & "excel" & came up with the
following link:
http://groups.google.com/groups?as_q=2147352571&as_ugroup=*excel*

I haven't checked them all but there must be something useful for you
in one of the 19 threads. One I did look at that seems promising is:
http://tinyurl.com/gymfw

Goodluck...

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...