dmw
06-12-2015, 06:49 AM
Hi,
I'm trying to find out how I can create a pop-up window in VBA asking to select a range myself, click "ok", and it then returns the SUM() value in the cell "D5". Is there a way to do this? I'll be honest, I don't know how to do this at all.
I have attached an example excel spreadsheet for reference.
The range I would like to select should be in column "B" starting in "B10". I appreciate any help.
I'm trying to find out how I can create a pop-up window in VBA asking to select a range myself, click "ok", and it then returns the SUM() value in the cell "D5". Is there a way to do this? I'll be honest, I don't know how to do this at all.
I have attached an example excel spreadsheet for reference.
The range I would like to select should be in column "B" starting in "B10". I appreciate any help.