MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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
PlateAComment = True
End If

Cheers... any ideas would be appreciated!

Posted by Juan Pablo G. on February 12, 2002 5:39 PM

Use the BeforeUpdate event instead.

Juan Pablo G.

Posted by Daniel James on February 12, 2002 10:54 PM

Cheers, i'll give that a crack and see how i go!