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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago