User Cell Picker & Summator Tool

The attached macro is designed to return the addresses of whatever cells are selected by the user.

Please Login or Register  to view this content.

This works perfectly. But what I am struggling to do is to use the retuned addresses in the formula bar of cell C12 so that all addresses are added together.

Cell Picker.png

Note: I am not looking for the macro itself to summate the cell contents, just to populate the formula bar of the 'Total' cell C12 with the addresses (separated with + symbols)...
...as this will allow the user to click on C12 to review what has been selected using the standard excel formula review coloured boxes (like below). I am also attaching the stripped back file for anyone who could help. Thanks!

fx.png

Ok so I think I have broken the back of this problem after a brain wave last night. See below code and attached file. This populates the formula bar of cell C12 with the user-picked cell addresses as required. Only untidiness is that when picking multiple cells the last address is followed by a comma when it is not required (see highlighted line below). If anyone can suggest any improvements to the code, then it would be welcomed.

Please Login or Register  to view this content.

Right! so I have manged to progress this to a point where I am pretty happy with the tool. BUT.....there is a bit of a flaw with the Intersect method which I do not know how to get around. If the user were to shift select starting with a cell within the data set, but finishing on cell(s) outside of the data set, it will see this as a valid input and run.

Is there anyway to avoid this and have the Intersect function check ALL selected cell addresses appear within the dataset???

Please Login or Register  to view this content.

Screen shot illustrating the problem:

fx.png