ExcelBanter - drop down box

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - drop down box (https://www.excelbanter.com/excel-worksheet-functions/86533-drop-down-box.html)

I have a file with many items(15000) in column A and their price in column B.
What I need to do is have a drop down box pop up when I position my cursor
over a price. This drop down box will have several percentage discounts for
me to choose from. i.e 50,55,60 and after choosing one of these give me the
answer. Do I need VBA for this?

Many thanks

Maybe use data validation, but that would be in column C, otherwise A gets
overwritten. Debra Dalgleish has details on her website at
http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"CJRolls" wrote in message
...
I have a file with many items(15000) in column A and their price in column
B.
What I need to do is have a drop down box pop up when I position my cursor
over a price. This drop down box will have several percentage discounts
for
me to choose from. i.e 50,55,60 and after choosing one of these give me
the
answer. Do I need VBA for this?

Many thanks