+ Reply to Thread
Results 1 to 3 of 3

Help adding inputbox values

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    Eugene, OR
    MS-Off Ver
    Excel 2010
    Posts
    43

    Help adding inputbox values

    I need help adding together two values that are entered by the user. Throughout this spreadsheet, I have only had to write one value to a cell which was easy. I'm not sure how to "add" the two values before sending the total back to cell B50. See portions of my code below. I have defined sUserInput12 and 14 as a string up til now....

    Please Login or Register  to view this content.
    If anyone could educate me on how to do this, I would really appreciate the help!
    Thank you -

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Help adding inputbox values

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Help adding inputbox values

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-08-2013
    Location
    Eugene, OR
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Help adding inputbox values

    Thanks - that worked except it was rounding the total, so I changed it from CSng to CDec and all is good! Thanks for your quick response.

+ 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. [SOLVED] Help with inputbox values
    By Ellen 2Excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2013, 01:30 PM
  2. [SOLVED] Trouble adding carrage return/line feed to application.inputbox message
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2012, 10:14 AM
  3. [SOLVED] Adding a field limitation (0-1 only) to a Private sub inputbox prompt.
    By Coachwooten in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2012, 12:10 PM
  4. InputBox values
    By daviddoria in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2009, 10:52 AM
  5. Exact values needed in InputBox?
    By deeppurple247 in forum Excel General
    Replies: 9
    Last Post: 01-17-2007, 07:09 AM

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