+ Reply to Thread
Results 1 to 8 of 8

Receive "$" and "," in an InputBox

  1. #1
    Registered User
    Join Date
    11-23-2013
    Location
    new york, ny
    MS-Off Ver
    Excel 2010
    Posts
    42

    Receive "$" and "," in an InputBox

    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.

  2. #2
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    210

    Re: Receive "$" and "," in an InputBox

    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!

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Receive "$" and "," in an InputBox

    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.

  4. #4
    Registered User
    Join Date
    11-23-2013
    Location
    new york, ny
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Receive "$" and "," in an InputBox

    It doesn't interpret $ or , correctly. I get a mismatch message.

  5. #5
    Registered User
    Join Date
    11-23-2013
    Location
    new york, ny
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Receive "$" and "," in an InputBox

    how do you do a double substitute? sorry for my ignorance..

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,634

    Re: Receive "$" and "," in an InputBox

    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.

  7. #7
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Receive "$" and "," in an InputBox

    Please Login or Register  to view this content.
    I don't. Curious

  8. #8
    Registered User
    Join Date
    11-23-2013
    Location
    new york, ny
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Receive "$" and "," in an InputBox

    Thanks for this!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  5. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. Replies: 5
    Last Post: 06-26-2006, 09:23 PM
  7. Replies: 7
    Last Post: 05-13-2006, 05:02 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1