Thread: drop down box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJRolls
 
Posts: n/a
Default drop down box

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