Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Who knows? With details beyond "it's not working," it would be easier to
identify the problem is, and suggest a solution. JLatham wrote: Debra, Could she have grabbed a control from the wrong toolbox? Controls vs Forms, or vice versa? "Debra Dalgleish" wrote: Are macros enabled in the workbook? susan wrote: http://www.contextures.com/xlDataVal10.html I have a cell that has a scroll-down list of names (made thru data validation) - data validation can't give me matching items in the list (has to scroll and click) so I found the solution in creating a combo box. I followed the example from the above link, tried it out and worked...but when i apply it to my own spreadsheet, it's not working. My list has 300+ items and I named the combo box to be the same as the example (so I don't have to change the VBA code). I don't want my users to have to scroll thru 300+ items to find their entry...I'd like to match at least to the first alphabet. is this possible? I don't know why the combo box is not working...can anyone help? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
All Worksheets in a Data Validation combo | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
hyperlink in combo box/data validation | Excel Worksheet Functions | |||
List, Combo Box, Data Validation?? | Excel Discussion (Misc queries) | |||
Combo Box or Data Validation | Excel Discussion (Misc queries) |