Is there a way that I can select multiple cells (they are formatted as numbers), and in a dedicated cell, have the value of the sums of those cells? If so, please share how! lol Thank you!\
Screenshot ... so if I select multiple numbers, I would like A4 to show the sum of all the selected cells.
Last edited by nkitchen31; 12-28-2019 at 04:45 PM. Reason: Screenshot
It would take some pretty tricky code to do it based strictly on what you select since it would have to operate from an event trigger, and the event trriggers as you make a selection change or a value change in a cell. But you could attach the code below to a button and when you have finished making your selection, click the button.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Dude ... that was perfect! Thank you! Where in FL are you by the way? So I am.
Try this code on the worksheet module of the workbook
Please Login or Register to view this content.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
That's perfect. Thanks!!Originally Posted by saravnepali
Try this code on the worksheet module of the workbook
Please Login or Register to view this content.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
If THIS HAS HELPED YOU PLEASE CLICK "* Add Reputation" as a way to say thank you.
About 120 miles northeast of you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks