+ Reply to Thread
Results 1 to 1 of 1

Multiple column value check with auto sum - could this be improved?

  1. #1
    Registered User
    Join Date
    07-20-2015
    Location
    Netherlands
    MS-Off Ver
    Win10, Off2019-365
    Posts
    44

    Multiple column value check with auto sum - could this be improved?

    Hello all,

    Today I was working on a small assignment and I decided to share it with this community as
    1) it might be of value to others and
    2) I am curious if it could be done in another/shorter way.

    The assignment was: make a table where users can enter values which are automatically
    summed, but users must also be able to fill in a value as total instead of entering (any)
    separate values. In case a total had been given, but (any) separate values are
    entered later on, they must be summed after all (so then the sum function must be restored).

    autoSumMultipleCells.PNG

    This is the code in the sheet module:
    Please Login or Register  to view this content.
    That's quite a bit of code for a relatively simple task - I wonder - could this be done in a shorter, simpeler way?
    (I would have attached the sample file if the Attachments button would've worked - in case you want it, send me a PM with your e-mail address.)

    Grtz, BartH
    Last edited by BartH_NL; 02-27-2018 at 02:29 PM.

+ 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] User form: with check boxes how do i allow MULTIPLE auto filters to run at the same time
    By liamfrancis2013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2016, 09:13 AM
  2. Replies: 3
    Last Post: 08-09-2015, 06:58 PM
  3. VBA: code check to auto copy and paste into new column
    By puekey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2014, 12:43 AM
  4. Replies: 0
    Last Post: 04-03-2014, 11:41 AM
  5. [SOLVED] Need your help regarding for multiple criteria check with multiple column.
    By Sanjibghorui in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2014, 09:14 AM
  6. [SOLVED] UserForm Auto Check check boxes if TextBoxes are not empies
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2013, 11:36 AM
  7. [SOLVED] Check if part of a column contains multiple values
    By singerj6 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2012, 01:21 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