Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Trapping on Data Entry
Good morning --
I'm creating a form to accept user info, and don't understand how to "scrub" the input data in VBA. For example, I'd want an appropriate error message if the user put a letter in a phone number. In VB, I'd use the "e.cancel = true" approach, but don't know how that works in VBA for Excel. In VB, I'd create the Sub using "ByVal e as System.EventArgs", but that doesn't seem to be an option here. I'm using Excel 2003. Thanks in advance for any guidance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
while deleting rows it finds an error - error trapping | Excel Programming | |||
Error Trapping when getting external Data | Excel Programming | |||
Error Trapping | Excel Programming | |||
Trapping Data Input with Curser Keys or Entry Key | Excel Programming | |||
trapping error | Excel Programming |