Help with inputbox (Distinguish OK from Cancel)

[NooK]

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

 

[mike]

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

 

[Norman Jones]

Hi NooK,


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

 

[NooK]

Thanks a lot mostly appreciated.

Worked like a charm.

Best Regards

Noo