Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All:
I have a code that will give me a input box to add name to the list. newName = Application.InputBox("Type new student name:", "Add Student", "New Student", Type:=2) If newName = "" Or newName = "FALSE" Then Exit Sub End If My problem is that the input box has OK, Cancel and the X windows default close option in top upper right corner. If I add a name and press OK all is fine. However the cancel and close window option will create a name called FALSE. How would I make it exit sub once those to functions are pressed. Regards Ardy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Input Box Cancel | Excel Discussion (Misc queries) | |||
Input Box - CANCEL | Excel Worksheet Functions | |||
Input Box - Hit cancel | Excel Programming | |||
Input box to cancel sub when Cancel is clicked. | Excel Programming | |||
cancel input | Excel Discussion (Misc queries) |