+ Reply to Thread
Results 1 to 5 of 5

summing variables with vba?

  1. #1
    Registered User
    Join Date
    10-04-2011
    Location
    Salem, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    60

    summing variables with vba?

    On a UserForm in a commandbutton.click sub I have variables Rd(1 to 50) Dimmed as Double. The values are loaded into textboxes by user and then each value is added to the appropriate Rd(x) variable.....So Far, So Good.

    I'd like to get the sum of all these into variable RdT Dimmed as double also without having to insert their values into a cell on a WS. All searches have led me to summing values in cells not variable values. Is there a way to do this using code within the commanbutton.click sub?

    TIA,

    Don

  2. #2
    Registered User
    Join Date
    11-01-2012
    Location
    Cairo, Egypt
    MS-Off Ver
    MS Office 2013
    Posts
    76

    Re: summing variables with vba?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-04-2011
    Location
    Salem, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: summing variables with vba?

    Geeeesh...so simple, I guess my brain just freezes at times....lol Thanks for the input and so quickly...

    Don

  4. #4
    Registered User
    Join Date
    11-01-2012
    Location
    Cairo, Egypt
    MS-Off Ver
    MS Office 2013
    Posts
    76

    Re: summing variables with vba?

    You're Welcome , Thanks for Reputation

    Kindly, Consider marking the thread as "Solved"..

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,463

    Re: summing variables with vba?

    Have you tried

    Please Login or Register  to view this content.

+ 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 Summing Duplicates, deleting rows after summing and filling col. for unsummed
    By solidrock1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 09:11 AM
  2. [SOLVED] Summing data based on 3 variables
    By BillDoor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-11-2013, 08:17 AM
  3. Merging multiple rows to one row and summing the variables
    By dhobbs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2013, 05:47 PM
  4. Summing values based on variables
    By giejack in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-10-2012, 01:02 PM
  5. Replies: 7
    Last Post: 09-08-2010, 12:29 PM
  6. Summing with Variables
    By budvegas in forum Excel General
    Replies: 24
    Last Post: 02-22-2010, 11:41 AM
  7. summing cells with variables
    By jeff in forum Excel General
    Replies: 5
    Last Post: 03-03-2005, 04:06 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