Capture vbCancel of input box (2000)

Topic

New Reply

I have the following code:
strReturn = InputBox(“please enter something”)
if strreturn = vbcancel
‘User pressed cancel
else if IsEmpty(strreturn)
‘User pressed okay without entering anything
else
“user entered something go on validating.
endif

This code errors as the strrturn is of different type to vbcancel.

How do you capture a vbcancel of an input box?

Thank you in advance
Cindy

Reply | Quote

Replies

The InputBox function returns an empty string "" if the user cancels it. There is no way to determine whether the user deliberately left the box empty and pressed OK, or pressed Cancel.

Reply | Quote

Thanks Hans,

I guess I shall just use the empty string as a cancel and assume if the user didn’t enter anything best we cancel what ever they are doing as they aren’t certain themselves.

Thanks

Cindy

Reply | Quote

Thanks Hans,

I guess I shall just use the empty string as a cancel and assume if the user didn’t enter anything best we cancel what ever they are doing as they aren’t certain themselves.

Thanks

Cindy

Reply | Quote

Doesn’t post 393694 cover this?

Reply | Quote

Good point, I had forgotten about that one. Thanks for digging it up.

Reply | Quote

Good point, I had forgotten about that one. Thanks for digging it up.

Reply | Quote

Doesn’t post 393694 cover this?

Reply | Quote

The InputBox function returns an empty string "" if the user cancels it. There is no way to determine whether the user deliberately left the box empty and pressed OK, or pressed Cancel.

Reply | Quote