Application.InputBox Throwing Type Mismatch Error

Hello all!

I'm having an issue with application.inputbox throwing a type mismatch error. I'm currently using the application.inputbox to prompt the user to name a new worksheet. I'm using the application.inputbox method because I am able to capture the cancel button click by testing whether the value returned is "false".

The issue that I'm running into is that when I input a string of numbers everything passes through just fine. If I click "cancel" then everything works fine. If I input a single letter character into the inputbox I get a type mismatch error. For the life of me I am unable to figure out why it's doing this.

Any help or suggestions would be greatly appreciated.

Here is the code that I'm using:

Please Login or Register  to view this content.

Thanks so much for your reply!

Originally Posted by JLGWhiz

Your first input box correctly identifies the data type as string, Type:=2.
The second input box does not specify the data type so it uses default which is String.

When tested, specifying the data type as string didn't make any difference, I still received the same error 13.

Originally Posted by JLGWhiz

Both should produce error 13 if you enter numbers because you have declared SheetName as String in your declarations. The InputBox function will produce only string data.

It actually worked opposite to what you've described. When I pass "123456789" as a value- no problem. When I pass "Another Sheet"- I get error 13.

When adding a watch to the SheetName variable, both "123456789" and "Another Sheet" cause the variable to become type String.

I got it working by formatting the SheetName variable with CStr(SheetName). While this works, there is one issue: if the user attempts to name their worksheet "false", the sub will terminate because it thinks the cancel button on the inputbox was clicked.

Please Login or Register  to view this content.

This will work in the meantime however if anyone has a better idea I'd love to hear it. Also, if anyone knows why I was getting an error 13 with my original code, please let me know.

Originally Posted by JLGWhiz

If you have people who name worksheets "True" or "False" they should not be working there very long.

I’m with you. I think that the saying “make something idiot-proof and they’ll just find a way to build a bigger idiot” came from my company.