Please help.. about InputBox command

[Seven]

Please help me...
With InputBox command ,when inputbox show for input data.
1.If I don't input anything in box and then push OK button.
It return data "" value.
2.If I push cancel button (nothing in box).
It return data "" value too.

how can i separate that I push cancel button or I don't
input anything and push OK button.

Thank you very much..
Seven

 

[Dan Artuso]

Hi,
You could use the 'default' argument to make sure something is in the text box
so that it is never blank.
Read up about it in Help.

 

[TC]

Yes, it is very ^%$#@!ing annoying.

There is no way around it except:

- use a special default value (like Dan said), or

- write your own form to look like an inputbox but handle the cancel button
properly.

Or, a thought! Try setting the default value of the inputbox to a

non-displayable< character: perhaps chr$(9). Then see if you can test for

that on return from the listbox. Post back whether this does or does not
work.

HTH,
TC

 

[seven]

Ok.. I will try. or I should make form for this.

-----Original Message-----
Yes, it is very ^%$#@!ing annoying.

There is no way around it except:

- use a special default value (like Dan said), or

- write your own form to look like an inputbox but handle the cancel button
properly.

Or, a thought! Try setting the default value of the inputbox to a you can test for
that on return from the listbox. Post back whether this does or does not
work.

HTH,
TC





.