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!
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!