Leith was kind enough to to put a great combo box together for me (see attached). Is it possible for the drop down list to open on type or do you always have to click the arrow?
Thank you!
Leith was kind enough to to put a great combo box together for me (see attached). Is it possible for the drop down list to open on type or do you always have to click the arrow?
Thank you!
Last edited by sick stigma; 02-20-2009 at 09:11 AM. Reason: clairifacation
Do you mean autofill? If so you need to use a ComboBox from the Controls ToolBox
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hello Sick,
The following event code will automaticlly drop the list when the cursor is placed in the control. This has been added to the attached worksheet.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks