Data validation - combo box
 

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!

Data validation - combo box
 

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.


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

Data validation - combo box
 

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

Data validation - combo box
 

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

Data validation - combo box
 

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