+ Reply to Thread
Results 1 to 7 of 7

Can't get addition to fit?

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Can't get addition to fit?

    Hi,

    Can anyone advise how I can inject:

    TextBox35.Value = TextBox9.Value + TextBox13.Value * 4.49)/1000

    to my existing code?



    Please Login or Register  to view this content.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Can't get addition to fit?

    Try
    Please Login or Register  to view this content.
    Actually, you might want to do this, so the accurate (un-rounded) value is preserved in the .Tag while the rounded value is shown in the text box.

    Please Login or Register  to view this content.
    Last edited by mikerickson; 11-03-2016 at 10:47 AM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't get addition to fit?

    Compile Error
    Attached Images Attached Images

  4. #4
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't get addition to fit?

    Still error, or am I doing something wrong?
    Attached Images Attached Images

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Can't get addition to fit?

    In both of the two recent pictures, I see mismatched parentheses. In post #3, the red statement appears to have one more closing parenthesis than opening parenthesis. In post #4, the red statement has one more opening parenthesis than closing parenthesis. I have not gone through the statements to see exactly what they are trying to do, but I expect it should work fine if you get the parentheses matched up properly.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't get addition to fit?

    OK thanks I'll amend now

  7. #7
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't get addition to fit?

    Ok got it working now, thank you very much

+ 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. Vba addition help
    By shotta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2013, 06:51 PM
  2. Need help with addition
    By misterman in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-17-2012, 04:07 PM
  3. How to do this addition?
    By Lewis Koh in forum Excel General
    Replies: 2
    Last Post: 05-21-2009, 02:00 AM
  4. Addition of cells.
    By hog in forum Excel General
    Replies: 9
    Last Post: 02-09-2007, 05:38 AM
  5. [SOLVED] Addition?
    By Frodo in forum Excel General
    Replies: 3
    Last Post: 07-22-2006, 08:20 AM
  6. [SOLVED] Sum vs. Addition
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2006, 04:10 PM
  7. addition
    By dali in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-04-2006, 02:40 PM
  8. row addition
    By Threshold in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2005, 04:06 PM

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