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!!