| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Discussion (Misc queries) | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Worksheet Functions | |||
| Avoiding Value error message due to space in cell w/ formula | Excel Discussion (Misc queries) | |||
| Avoiding the dreaded #div/0 error | Excel Worksheet Functions | |||
| Input Date when data is entered into another cell | Excel Worksheet Functions | |||
Threaded Mode
