Data validation - combo box

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

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!
 
Susan,
I know of the handy function that you're referring to. I remember the first
time I tried setting it up to try it out that I had trouble getting it to
work for me. I had to go back and really pick through the process and follow
all the instructions slowly and carefully and it ended up working just fine.
So, for the moment, that's my suggestion: try again, making sure to follow
Debra's instructions step by cautious, careful step.
 
Are macros enabled in the workbook?
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!
Click to expand...
 
Debra,
Could she have grabbed a control from the wrong toolbox? Controls vs Forms,
or vice versa?
 
Who knows? With details beyond "it's not working," it would be easier to
identify the problem is, and suggest a solution.
 
Back
Top