Sum values from multiple drop down box selection

Hi All,

I'm super new to excel (so apologies if this isn't explained 100%) but have been researching certain things to create a spreadsheet how I want it.

I've used a VBA code I found online which allows me to select multiple options from a drop-down box and create a list within one cell.

Please Login or Register  to view this content.

I'm unable to share a screenshot of my specific table due to being work related however, I've attached a dummy worksheet with the same set up I've got.

So the dropdown box has option 1, option 2, option 3, option 4, etc.
The VBA code allows me to pick as many of those, with repetition.

I've created a table with a corresponding price, for example, option 1 is worth $50, option 2 is work $70, option 3 is work $80.
If i select option 1, 2 and 3, I want this to sum together in another cell to create a total, which would be $200 if those 3 options were selected.

I've created a table with the source for the drop down, with the price in the cell next to each option.
I've tried a VLookup, however this only gives me the price of the first option I had selected. Using the above example, it only gives me $50 as that's how much option 1 is worth, it doesn't add the 3 amounts together based on my selections.

I'm hoping there's either something I can add into my VBA or a formula of some sort that works with the VBA code i've put in.

Thank you in advance!

Hi, welcome to the forum

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Also, To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Originally Posted by stephdlog

Hi...Wasn't sure if I needed to start a new thread....

Yes you do