Hi Guys!
I'm having trouble validating the following InputBox. The InputBox is asking for a revenue number which will be plugged into a cell. In anticipation of the user entering one of the following, how can I ensure that only the number gets entered into the cell.
Ex. $1,000, $1000, 1,000, 1000.00.
Currently, the only type that doesn't give me a mismatch is "1000".
Please Login or Register to view this content.
Not sure if there is a better option, but you could just do a double substitute and replace the $ and , with ""s.
Want to show appreciation for the help you received from a member? Give them reps by clicking the bottom left of their post!
Remove the Val. Excel should interpret the results as currency and act accordingly
If you are happy with my response please click the * in the lower left of my post.
It doesn't interpret $ or , correctly. I get a mismatch message.
how do you do a double substitute? sorry for my ignorance..
just do it twice
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I don't. CuriousPlease Login or Register to view this content.
Thanks for this!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks