Rather than using the quirky RefEdit control on a form, I've elected to use the Application.Inputbox(...,8) method.
My question is this: If I use type 8 (returns a range object), why would the method return a Boolean False when "Cancel" is pressed??
This doesn't make sense to me. For example,
Set XRng = Application.InputBox("Select the X Range", "X-Range", , , , , ,
If the user selects a range and clicks "OK" then we're in business. But, if they click cancel, the method returns "False", clearly not a range object, and I get a type mismatch error for using the Set statement.
Am I missing something, or does the design of the method not make sense?
Thanks,
Doug
My question is this: If I use type 8 (returns a range object), why would the method return a Boolean False when "Cancel" is pressed??
This doesn't make sense to me. For example,
Set XRng = Application.InputBox("Select the X Range", "X-Range", , , , , ,
If the user selects a range and clicks "OK" then we're in business. But, if they click cancel, the method returns "False", clearly not a range object, and I get a type mismatch error for using the Set statement.
Am I missing something, or does the design of the method not make sense?
Thanks,
Doug