VBA code required

[hadham]

Hi all; I will be grateful if you provide me with a VBA code for the following:

1. A dialog will be opened and ask the user to choose the cells (could be separate cells not a regular range)(all cells are numeric values)
2. Another dialog will pop up with the cells chosen for the user to confirm.
3. A dialog will open to ask the user to choose the destination workbook
4. After opening the target workbook, a dialog will open to ask the user to select a sheet and then a cell in that sheet
5. In that particular cell, the sum of the chosen cells will appear
6. A dialog will pop up asking the user to if he needs to repeat the above in the same opened workbook, if yes then it will go to strep 1 above skipping step 4 but choosing another cell in the target workbook
7. If the user prompts to say no, both workbooks will be saved and kept open.

With many thanks;;;

 

[Yongle]

Re: VBA code required, please

How does the user select workbook to open?
- is it always in a specific folder?
- do possible file names have anything in common?
- is there only one sheet in the workbook being opened?
- is the cell selected in a specific range?


Trying to see if we can make it easier for the user

 

[hadham]

Re: VBA code required, please

Thank you for responding, below my answers in red:
How does the user select workbook to open? The normal excel window will open to choose the location and the workbook
- is it always in a specific folder? not necessary
- do possible file names have anything in common? No
- is there only one sheet in the workbook being opened? could be more than one sheet
- is the cell selected in a specific range? No the user will select one or more cells from the sheet, not necessarily in sequence