Drop Down List and Function VBA
Hi Everyone,
I have written a function called CUSTOMSUM and the input value (highlighted in yellow) will be multiplied by a number depending on which item I chose from the drop-down box.
The function works in excel but I will need to refresh it everytime for the code to work.
Could someone please advise. I don't want to print the number out for each fruit so I stored it in a variable.
Thanks!!
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago