RE: Change Event in UserForms
Posted by Daniel James on February 12, 2002 5:02 PM
Hey, i'm trying to use the change event on a TextBox in my form, in order to change another field, depending on the value entered. This works fine, but, if for instance, i enter a '1', and then backspace (as if i'd entered the wrong number), it throws and type mismatch error, which i haven't been able to get around.
Sample Code:
Sub PlateABox_Change
If PlateABox = 0 Then
PlateAComment = False
Else
PlateAComment = True
End If
Cheers... any ideas would be appreciated!