Help with inputbox (Distinguish OK from Cancel)

N

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
 
M

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
 
N

Norman Jones

Hi NooK,


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