Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down box
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |