Run-Time Error ‘13’: Type Mismatch in Userform

Your trying to put numeric results in a textbox it seems. You will likely need to convert the result to a string to be able to asign the value to a text box.

see the cstr function.

Keep in mind that the value in the textbox is then a string and not a number, so you may need to convert it back to a numeric value if "extracting" it from the text box for calculations after.

Originally Posted by Norie

You don't need to convert numeric values to strings to put them in textboxes but there could be problems when using (text) values from textboxes in calculations.

Also, if any of the textboxes you are using in the calculation is empty it could cause problems.

Ah actually thats a good point, its the issue is likely trying to do the math using the values from the text boxes, not storing the result in the text box like I said. Conceptually similar tho. Converting the values in the text boxes to numeric values prior to or within the calculation. You should check out the conversion functions to see which most closely resembles the type of numeric values you work with (Cdbl, Cint, etc)

Dear Friends,

Thanks for your instant responses!

As Mr. Norie said, there was a empty text box which used in my calculation, same is been corrected and code is working Fine Now!

Regards,
Rajeshkumar R