drop down list w/out drop down box 
Author Message
 drop down list w/out drop down box


>I want a particular cell to be forced to a finite group of text values (from
>a cell range). This can easily be done with a forms box called the Drop-Down
>box, but is there a way for the cell to do it by itself so that the text can
>be in the cell?

Using the Data Validation Command will store the text in the required

In the cell, select Data, Validation
On the SETTINGS tab, select Allow, List
In the source box, highlight the cell range holding the allowable values
You can then customize the Input and Error messages
If you don't want the drop down arrow to show, deselect the "In-Cell
DropDown" box on the settings tab.


Susan Roberts

Sat, 23 Sep 2000 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. unbound drop-down list box to limit the values in another drop-down list box

2. Drop Down Box depending upon another Drop Down Box

3. Data Validation Drop down list ( make longer drop box)

4. XL95/XL97 - Using a drop-down selection to load a fill range in another drop-down

5. restrict drop down menu based on previous drop down menu

6. Drop Down within a Drop Down

7. Drop down menus keep popping up &dropping down

8. Add list to the Dropped Down List (Combo Box)

9. Drop Down Box Slowing Down Calculation

10. Selection from drop down list does not show in text box part of combo box

Powered by phpBB® Forum Software © phpBB Group