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.