jaybird2569
New Member
- Joined
- Sep 28, 2016
- Messages
- 22
Good afternoon,
I am just beginning with VBA and use this site quite often for guidance, now I need to post a question of my own. I have a worksheet with multiple columns where I need to know the sum of mixed cells. I would like the macro to start off with a message box instructing to select a column to perform the function then after selecting a column heading (B, C, D, etc) the macro would complete four separate functions and provide the results in a message box. An example would be after the prompt to select a column, user selects column C, the macro adds cells 3 & 6 for one total, cells 4 & 7 for another total, cells 5 & 8 for another total and cell 10 for another total then provides all 4 totals in one message box. The cells I would be adding would always be the same, only the user selected column would change.
I am just beginning with VBA and use this site quite often for guidance, now I need to post a question of my own. I have a worksheet with multiple columns where I need to know the sum of mixed cells. I would like the macro to start off with a message box instructing to select a column to perform the function then after selecting a column heading (B, C, D, etc) the macro would complete four separate functions and provide the results in a message box. An example would be after the prompt to select a column, user selects column C, the macro adds cells 3 & 6 for one total, cells 4 & 7 for another total, cells 5 & 8 for another total and cell 10 for another total then provides all 4 totals in one message box. The cells I would be adding would always be the same, only the user selected column would change.