Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list/Combo box?
Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9. In a second range C18:K18 I would like to have the following (if possible): If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box with values "Yes" and "No". Can this be done? Sandy ps I know I posted this on Public.Excel but I then thought this was a more appropriate section |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list/Combo box?
Check your other post.
Sandy wrote: Hi I have a range of cells C6:K6 which contains numbers from 3 to 9. In a second range C18:K18 I would like to have the following (if possible): If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box with values "Yes" and "No". Can this be done? Sandy ps I know I posted this on Public.Excel but I then thought this was a more appropriate section -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list/Combo box?
I've done so Dave - Thanks
"Dave Peterson" wrote in message ... Check your other post. Sandy wrote: Hi I have a range of cells C6:K6 which contains numbers from 3 to 9. In a second range C18:K18 I would like to have the following (if possible): If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box with values "Yes" and "No". Can this be done? Sandy ps I know I posted this on Public.Excel but I then thought this was a more appropriate section -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Drop Down List or Combo Box | Excel Worksheet Functions | |||
drop-down list(or combo-box) for the cell | Excel Discussion (Misc queries) | |||
Combo drop down list | Excel Programming | |||
Drop Down List Box, Combo Box | Excel Discussion (Misc queries) | |||
Drop down list or combo box help needed | Excel Discussion (Misc queries) |