What I'm trying to get done is to force the user to select a number. If they exit the input box, then nothing happens. If they enter anything other than a number, they get the "insert number" message box.
Please Login or Register to view this content.
Works until I enter a non-numerical character. Then it returns the type mismatch error. Help.
Last edited by lediable007; 06-11-2016 at 09:59 PM.
In this line of code
Remove the square bracket after the 2Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks for responding so quickly, Alan.Originally Posted by alansidman
In this line of code
Remove the square bracket after the 2Please Login or Register to view this content.
Done. Same issue. If I enter anything other than a number, it throws me the type mismatch error.
That is because you have defined myNum as an integer. Try changing it to a Variant and see if that solves your issue.
That was the issue. Thanks much, Alan. Threw you some rep!
LD
Let Excel do the number/string validation, by setting the Type argument.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
That also works well. Thanks, Mike! Threw you some rep too.Let Excel do the number/string validation, by setting the Type argument.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks