Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
What code gives SUM of user-selected cell range on a sheet?
I solved this myself, although the original idea has changed somewhat, it works for me. I used an Input box to insert a range of cells into my code. Now if I want to total a column of figures I select the cell where I want my total to be displayed and click the command button. The Input Box...- robocorp
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
What code gives SUM of user-selected cell range on a sheet?
I want to code the click event of a command button to sum a range of currency formatted cells that I select in a worksheet, and then display the result in a label or text box with the same format. What do I need? Any help is greatly appreciated, thanks!!- robocorp
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
