+ Reply to Thread
Results 1 to 6 of 6

Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet?

  1. #1
    Registered User
    Join Date
    12-21-2011
    Location
    Nashville, TN
    MS-Off Ver
    Office 365 Excel
    Posts
    20

    Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet?

    Hi all,

    I need (in a hurry) a simple macro that recognizes a clicked cell and transfers the contents of that cell to another accumulating sum of the contents of the cells clicked. Any help is highly appreciated. Thanks much in advance.

    Best, Nash

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,005

    Re: Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet

    Quote Originally Posted by naragam View Post
    in a hurry


    Quote Originally Posted by naragam View Post
    recognizes a clicked cell and transfers the contents of that cell to another accumulating sum


    Accumulating sum in "G2" cell of active sheet:
    Please Login or Register  to view this content.
    Last edited by mjr veverka; 01-28-2021 at 08:18 PM.

  3. #3
    Registered User
    Join Date
    12-21-2011
    Location
    Nashville, TN
    MS-Off Ver
    Office 365 Excel
    Posts
    20

    Re: Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet

    Quote Originally Posted by naragam View Post
    Hi all,

    I need (in a hurry) a simple macro that recognizes a clicked cell and transfers the contents of that cell to another accumulating sum of the contents of the cells clicked. Any help is highly appreciated. Thanks much in advance.

    Best, Nash
    Thank you very much for helping me. It looks good and I will be trying it out immediately!

    Best, Nash

  4. #4
    Registered User
    Join Date
    12-21-2011
    Location
    Nashville, TN
    MS-Off Ver
    Office 365 Excel
    Posts
    20

    Re: Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet

    Thank you very much for helping me. It looks good and I will be trying it out immediately!

    Best, Nash

  5. #5
    Registered User
    Join Date
    12-21-2011
    Location
    Nashville, TN
    MS-Off Ver
    Office 365 Excel
    Posts
    20

    Re: Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet

    Quote Originally Posted by porucha vevrku View Post






    Accumulating sum in "G2" cell of active sheet:
    Please Login or Register  to view this content.

    Hi again,

    I am not sure what might be wrong with my Office 365 Excel version, but I can't seem to be able to get your code plugged into my spreadsheet and debug using stepping line by line. I can't get into execution mode although I am using the "Developer" tab needed in my Excel top menu! Can you please give me some simple instructions to plug in the macro into my worksheet? It's been a while since I have used macro in my excel and it looks like I need a tutorial. Any help?

    Thanks much in advance,

    Nash

  6. #6
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,005

    Re: Finding a simple macro to add cells at random depending on a "clicked" cell on a sheet

    Copy code, then right (mouse button) click on any/some sheet tab (e.g. "Sheet1") and choose 'View Code', then paste code in sheet module.
    Change "G2" to the cell address where you want to sum the values from other cells you clicked, then close sheet module.

+ 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. Finding the Difference between "random" cells
    By kcrasch in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2018, 12:06 PM
  2. [SOLVED] Macro not Finding "blank" visible cells (when filtering
    By ExcelMasterIamNot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2015, 09:12 PM
  3. macro to record value "1" depending on another cell value being highest in range
    By semajjames in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2015, 07:24 PM
  4. [SOLVED] Help Needed Urgent with Macro to copy cells to new sheet if cell="y"
    By Amanda, in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-28-2014, 04:18 PM
  5. Option to hide the sheet when "Disable Macros" is clicked
    By sivdin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-06-2009, 11:07 AM
  6. Replies: 6
    Last Post: 01-08-2006, 06:20 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