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

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

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/

Thanks a lot mostly appreciated.

Worked like a charm.

Best Regards

Noo

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