VBA Setting value error
 

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 |
+-------------------------------------------------------------------+

--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=544636

VBA Setting value error
 

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

VBA Setting value error
 

Hi,
Just did a quick google for your error # & "excel" & came up with the
following link:
http://groups.google.com/groups?as_q...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...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=544636