How to check if user clicks on Ok or Cancel in inputbox?

lets call your variable myString

Cancel can be detected by

Please Login or Register  to view this content.

OK with an empty string can be detected by

Please Login or Register  to view this content.

Thank you for your response AskMeAboutExcel. I tried your suggestions, however, when I click "Cancel" now, the check for VbNullString is fulfilled and the code below this condition is executed.

Here's a snippet of my code:

Please Login or Register  to view this content.

When I click cancel, the msgbox is still shown (It should be shown when I click OK)

Why is this happening?

Edit: When I change the order of the elseif statements, it works. The code is:

Please Login or Register  to view this content.

But the order of the elseif shouldnt matter right? Whats wrong here?

Originally Posted by aks2161989

But the order of the elseif shouldnt matter right? Whats wrong here?

If you press cancel, StrPtr(iBox) = 0 and iBox = vbNullString are both true.
If you press ok with no input, only iBox = vbNullString is true

Therefore if you put vbNullString as the first elseif test, it will always run that logic, and not test StrPtr(iBox) = 0