Please help.. about InputBox command

  • Thread starter Thread starter Seven
  • Start date Start date
S

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
 
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.
 
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
Click to expand...
that on return from the listbox. Post back whether this does or does not
work.

HTH,
TC
 
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





.
Click to expand...
 
Back
Top