Source of zero length strings from an input box

  • Thread starter Thread starter Rob F
  • Start date Start date
R

Rob F

Hi

I've got an input box in a macro, with a default string
defined.

If a user presses the cancel button, that results in the
return of a zero length string. Fair enough.

However, if the user clears the default string from the
input box and presses OK then that also returns a zero
length string!

I need the macro to do one thing in the first
circumstance, something else in the second.

How can I differentiate between a "system" generated zero
length string, and a "user" generated one?

Thanks

Rob F
 
I don't know of a way to tell the difference. I'd use a custom form with an
OK and Cancel button myself if I needed to tell the difference.
 
Back
Top