Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default drop down lists identifiers

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default drop down lists identifiers

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default drop down lists identifiers

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default drop down lists identifiers



"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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default drop down lists identifiers

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default drop down lists identifiers

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default drop down lists identifiers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I use one drop-list to modify another drop-lists options? [email protected] Excel Discussion (Misc queries) 3 September 9th 07 06:46 PM
Drop down lists Jack Excel Discussion (Misc queries) 3 June 1st 07 02:19 PM
Multiple lists with repeated values for dependet drop down lists mcmanusb Excel Worksheet Functions 1 September 29th 06 01:13 AM
drop-down lists JOHNEB Excel Discussion (Misc queries) 1 December 29th 05 01:41 AM
Drop Down lists cribology - ExcelForums.com Excel Discussion (Misc queries) 2 August 2nd 05 04:11 PM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"