Hi all,
I have a userform, which is updated by a barcode reader.
When i want to validate one of these textboxes which has to have a fixed input, i can not use "else".
the code is as below,
i want to show a msgbox after else, something like,![]()
Public Sub endtxtbx_Change() If endtxtbx.Value = "11EF" Then 'some codes here End If End Sub
but, when i do so, it'll only show the Msgbox by any changes.![]()
Public Sub endtxtbx_Change() If endtxtbx.Value = "11EF" Then 'some codes here else MsgBox "Invalid Input" End If End Sub
Any Idea where is the problem, or what is the solution to do something like this?
Bookmarks