View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Myrna Rodriguez Myrna Rodriguez is offline
external usenet poster
 
Posts: 23
Default Bypass Textbox Validation

Hi VB Bugs...

I created a userform with textboxes to facilitate data entry on Excel
spreadsheet. I validated the textboxes to display a message box if
empty.
Userform automatically appears when file is open.
However, if I decide not to input data on userform & wish to
CANCEL(unload userform), a message box still appears.
How can I bypass validation for textboxes and proceed to CANCEL form??

Thanks and will validate your sugguestions!!
Myrna

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!