Tweaking a dropdown box

Please don't create duplicate Posts as it wastes people time !!!

Your other post has been deleted

Now,

How about a non VBA way

If your trying to convert a name to a value so you can use in a formula you could use the name function.

Go to Insert > Name > Define then in Name in workbook enter Paid and in the refers to enter =11 and click ok

Then say your formula is = 11 * 17.5% your formula would noe look like

=Paid*17.5%

Hope this helps

VBA Noob