View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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