Results 1 to 4 of 4

Use BeforeDoubleClick to sum cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    570

    Use BeforeDoubleClick to sum cells

    Hello

    I have column L and it will be various of number of rows, is it possible to use doubleclick in cell L20, L21 and so on to sum M17+M16+M14, and sum it in cell L20, L21and so on, or must i use another emty cell to double click in for each row and how will that vba look like

    The values in M17, 16 and 14 will change often
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] getting a second BeforeDoubleClick to work on the same sheet
    By dyoung785 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-20-2017, 07:33 PM
  2. [SOLVED] BeforeDoubleClick or Shapes?
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-12-2015, 11:09 PM
  3. [SOLVED] BeforeDoubleClick: If Not Intersect
    By cocacrave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2015, 10:58 AM
  4. Use beforedoubleclick in several ranges
    By cajand in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-04-2014, 10:27 AM
  5. BeforeDoubleCLick
    By JoshBRCB in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-08-2012, 06:55 AM
  6. BeforeDoubleClick and protection
    By d.tiles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2010, 05:50 AM
  7. BeforeDoubleClick bug
    By bsalonzo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2007, 06:51 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