Help with inputbox (Distinguish OK from Cancel)
 

Is there any way to tell if the user has pressed Cancel in the input bo
or if he has pressed OK with the input field completelly empty?

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com

Help with inputbox (Distinguish OK from Cancel)
 

Create your own form! It's very simple!
If you really want to use this function, try with
a "default" non-blank value. You can then compare
resulting value with intitial one.
mike

Help with inputbox (Distinguish OK from Cancel)
 

Hi NooK,


Try using Application.InputBox which returns either a zero length string or
a boolean False in your described cases.


---
Regards,
Norman



"NooK " wrote in message
...
Is there any way to tell if the user has pressed Cancel in the input box
or if he has pressed OK with the input field completelly empty?

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/

Help with inputbox (Distinguish OK from Cancel)
 

Thanks a lot mostly appreciated.

Worked like a charm.

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com