Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It there not really a direct way to tell if the Cancel button was clicked of
an InputBox. I was told in an earlier posting to do something like this: EnterState = InputBox("Enter State: ") If EnterState < "" Then ActiveCell.Value = EnterState Else ActiveCell.Value = Null Endif '----But---- What I want is if the cancel is pressed don't do anything. What is happening is if for example the current cell value is "Florida" ; and the InputBox opens and the person puts "North Carolina" in the InputBox field and then changes their mind and clicks Cancel, then the cell value is erased....when it should still say "Florida" How do you catch the Cancel key press and tell it don't do anything. Thank you for your help. Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Input Box Cancel | Excel Discussion (Misc queries) | |||
Input Box - CANCEL | Excel Worksheet Functions | |||
Input box to cancel sub when Cancel is clicked. | Excel Programming | |||
Input box cancel | Excel Programming | |||
cancel input | Excel Discussion (Misc queries) |