LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LilaDuncan
 
Posts: n/a
Default Drop down list question

Please can anyone help me with this query?

When I came to make a drop down list for data entry in a cell, I used
the method:
Select cellMenu
BarDataValidationAllow:ListSource:Yes,No,Undec ided.

When I went to the origial workbook I was using for an example and go
to: Select cellMenu BarDataValidationAllow:ListSource: The source
field shows: =Choices.

The only cell in the 3 sheet example workbook showing the entry:
Choices, is the heading of the column where the drop down
"Yes,No,Undecided" cells are located. There is no text defining the
Yes,No,Undecided list choices there.
How would go about finding the place in the workbook where this
information is kept?

TIA
Lila

 
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
Pull unique names for drop down list [email protected] Excel Discussion (Misc queries) 3 February 1st 05 10:23 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM
drop down list question [email protected] Excel Discussion (Misc queries) 1 January 20th 05 06:53 PM
Drop down list question... GR Excel Worksheet Functions 2 November 28th 04 06:21 AM
Drop List Referencing Boony Excel Worksheet Functions 2 November 11th 04 11:42 AM


All times are GMT +1. The time now is 09:32 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"