Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In my XL2003 workbooks, I have a number of drop down lists. The small
indicator to the right only appears when I click on a cell with a list in it. I have seen spreadsheets where every list is permanently identifiable as the indicator is permanently visible. How is this done please Thanks in anticipation |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
You may have seen a combo-box. View|Toolbars|Forms From the forms toolbar put a combo-box on you wrksheet. Mike "dave caizley" wrote: In my XL2003 workbooks, I have a number of drop down lists. The small indicator to the right only appears when I click on a cell with a list in it. I have seen spreadsheets where every list is permanently identifiable as the indicator is permanently visible. How is this done please Thanks in anticipation |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In those spreadsheets, it is likely that they are using comboboxes, not data
validation. I just use a cell colour for the DV cells, works fine for me. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dave caizley" wrote in message ... In my XL2003 workbooks, I have a number of drop down lists. The small indicator to the right only appears when I click on a cell with a list in it. I have seen spreadsheets where every list is permanently identifiable as the indicator is permanently visible. How is this done please Thanks in anticipation |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "Mike H" wrote: Hi, You may have seen a combo-box. View|Toolbars|Forms From the forms toolbar put a combo-box on you wrksheet. Mike "dave caizley" wrote: In my XL2003 workbooks, I have a number of drop down lists. The small indicator to the right only appears when I click on a cell with a list in it. I have seen spreadsheets where every list is permanently identifiable as the indicator is permanently visible. How is this done please Thanks in anticipation |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Its just dawned on me that the Combo Box is floating and is not relevant to a
particular cell which is clearly why I cannot get the calculations to work. I guess my next question is, "Is it possible to link Combo Boxes to a particular cell ?" Many thanks "Mike H" wrote: Hi, You may have seen a combo-box. View|Toolbars|Forms From the forms toolbar put a combo-box on you wrksheet. Mike "dave caizley" wrote: In my XL2003 workbooks, I have a number of drop down lists. The small indicator to the right only appears when I click on a cell with a list in it. I have seen spreadsheets where every list is permanently identifiable as the indicator is permanently visible. How is this done please Thanks in anticipation |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Bob
Thanks for the reply. Have already tried that idea but it doesnt really get me to where I would ideally like to get to. Thanks anyway "Bob Phillips" wrote: In those spreadsheets, it is likely that they are using comboboxes, not data validation. I just use a cell colour for the DV cells, works fine for me. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dave caizley" wrote in message ... In my XL2003 workbooks, I have a number of drop down lists. The small indicator to the right only appears when I click on a cell with a list in it. I have seen spreadsheets where every list is permanently identifiable as the indicator is permanently visible. How is this done please Thanks in anticipation |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Its a bit convoluted but weve cracked it. Link the combo box to a cell and it
places a value in that cell. Use that number to create the argument in the formula "dave caizley" wrote: In my XL2003 workbooks, I have a number of drop down lists. The small indicator to the right only appears when I click on a cell with a list in it. I have seen spreadsheets where every list is permanently identifiable as the indicator is permanently visible. How is this done please Thanks in anticipation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop down lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
drop-down lists | Excel Discussion (Misc queries) | |||
Drop Down lists | Excel Discussion (Misc queries) |