Hi, really hope someone can help me with this one, I don't know VB at all, this is a new challenge for me and cant seem to resolve through web searching...
I am using Excel 2016.
So I have learned how to create an ActiveX listbox, how to populate the listbox and turn on MultiSelect.
My listbox currently shows the "Options" Range Column A (below)
My range of selected cells are;
<tbody>
</tbody>
What I want to be able to do is when I select say Option 1 and Option 3 or any combination, is to show an output into a specific worksheet cell, the product from the corresponding value of Column B
Eg if I click on Option 1 and Option 3 in the listbox the worksheet cell value would show "2.8" the sum of 1.4 x 2.0
Many thanks in advance for some help on next steps.
I am using Excel 2016.
So I have learned how to create an ActiveX listbox, how to populate the listbox and turn on MultiSelect.
My listbox currently shows the "Options" Range Column A (below)
My range of selected cells are;
Column A | Column B |
Options | Value |
Option 1 | 1.4 |
Option 2 | 4.2 |
Option 3 | 2.0 |
Option 4 | 9.1 |
<tbody>
</tbody>
What I want to be able to do is when I select say Option 1 and Option 3 or any combination, is to show an output into a specific worksheet cell, the product from the corresponding value of Column B
Eg if I click on Option 1 and Option 3 in the listbox the worksheet cell value would show "2.8" the sum of 1.4 x 2.0
Many thanks in advance for some help on next steps.