Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox on user form type mismatch
I have a textbox on a user form that is giving me an error when a
number is entered in. This number is a percent and the code for the textbox is: Private Sub TextBox35_AfterUpdate() If IsNumeric(Me.TextBox35.Value) Then Me.TextBox35.Value = Format(CDbl(TextBox35) / 100, "0.00%") End If End Sub This works fine only if I enter a whole number(?), meaning, 10, 12, 30, 44 all will work. But if I enter 10.3, then I get the error. Any thoughts on where I'm going wrong? There is another button on the form that when clicked will mulitply textbox1 x textbox35 + textbox1. So the flow is: 1) a value is in textbox1, 2) I enter in a 'markup', say 10.5 and click the button. The error comes up at that point, again, only if I use a '.'....in textbox35. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#13 type mismatch error on user form for Dave Peterson | Excel Discussion (Misc queries) | |||
Textbox on user form type mismatch | Excel Programming | |||
#13 type mismatch error on user form | Excel Programming | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming |