Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
All Worksheets in a Data Validation combo [email protected] Excel Worksheet Functions 1 November 11th 06 08:58 AM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
hyperlink in combo box/data validation Dannycol Excel Worksheet Functions 0 April 4th 06 11:23 PM
List, Combo Box, Data Validation?? JackieR Excel Discussion (Misc queries) 1 November 22nd 05 04:09 PM
Combo Box or Data Validation FA Excel Discussion (Misc queries) 17 September 27th 05 01:58 PM


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"