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 1 week ago
5 years 39 weeks ago
5 years 51 weeks ago
6 years 1 week ago
6 years 2 weeks ago
6 years 8 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago