View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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.