ERRORS in VBA FUnctions "InputBox" & "Select Case"

[Mackeral]

These 2 VBA expressions do not function as it the are documented to, and I found that these had been recently implimented and broke code I've been running for years.

INPUTBOX
The docmentation says that if you hit the "Cancel" key that the routine returns a FALSE.
It now returns an Empty String.

The workaround is to use the SetStr function to test for the Escape Key having been used:

Test = SetStr(Arg) = 0

"Arg" being the string returned from the InputBox call.

SELECT CASE
The documentation refers to using "Is" or "Like" prior to haing a calculation as part of a "Case" statement. Not only that these don't work; now you can't have any calculations in the "Case" statement. It does not respond to a TRUE or FALSE argument, only what has been presented in the "Select Case" statement.

 

[Jaafar Tribak]

One other question I have: How could I see the documentation you found?
Thanks,

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/inputbox-function

 

[Jaafar Tribak]

But I have another Case statement in my code which does work:

Case Function_Returing_TRUE_or_FALSE(Arg)   <-- Statement B

So what is the difference between Statement A and Statement B?

The B statement won't work either if the function returns a True or Flase boolean.