Thread: Avoiding error on Input Box - if no value is entered
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
  
Posts: 266
Default Avoiding error on Input Box - if no value is entered
I have a line like this:

MyData = InputBox(Prompt:="Enter Data", Title:="ENTER Data")

If the user selects "Cancel", I get a Run-time error 13 - Type Mismatch.
How can I avoid this error when the user selects cancel ? Thanks for any
help on this.
Reply With QuoteReply With Quote