Home |
Search |
Today's Posts |
#1
|
|||
|
|||
List boxes, drop down
Hi
2 question. i would like to use the data / validation function to restrict cell entry to certain data. I want to use a List which I reference rather than typing the data in the validation text box. However I want to have the list set up on a different sheet. I can do this if the list is set up on the same sheet. Any ideas? Also is there a way that the cell might autosuggest. For instance if the list contains the name "John" I would like if "john" pops up as soon as I enter "J". This appears only to work if John has alrady been entered on another record Thanks in advance -- Kevin |
#2
|
|||
|
|||
If you name that list (on the secondary worksheet), you can use that name in
data|validation. See Debra Dalgleish's site: http://www.contextures.com/xlDataVal01.html particularly: http://www.contextures.com/xlDataVal01.html#Name But the autocomplete doesn't work with data|validation. But it can work with a combobox from the control toolbox toolbar: http://www.contextures.com/xlDataVal11.html (also from Debra's site) Kevin wrote: Hi 2 question. i would like to use the data / validation function to restrict cell entry to certain data. I want to use a List which I reference rather than typing the data in the validation text box. However I want to have the list set up on a different sheet. I can do this if the list is set up on the same sheet. Any ideas? Also is there a way that the cell might autosuggest. For instance if the list contains the name "John" I would like if "john" pops up as soon as I enter "J". This appears only to work if John has alrady been entered on another record Thanks in advance -- Kevin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |