userform combobox - autocomplete with drop down box

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,735
has anybody got a snippet of code to make a combobox auto complete? as the user types in a name into the cbo, i would like them to be able to select from a list that drops down below the combobox.
 

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,735
thanks Akuini. I have inserted your snippet into my existing code where I think it should go. I get a Run time Error 70: Permission Denied error at
Code:
.List= d.keys
 

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,735
error because i was filling the cbo from RowSource. How do I adjust the code so that when an entry is backspaced away, the other form fields are deleted also? so by deleting the selected user from the cbo box, i want the first name, last name, phone, etc fields cleared. And need listbox cleared of selections if any?
 
Last edited:

Akuini

Well-known Member
Joined
Feb 1, 2016
Messages
2,364
Office Version
2013
Platform
Windows
How do I adjust the code so that when an entry is backspaced away, the other form fields are deleted also? so by deleting the selected user from the cbo box, i want the first name, last name, phone, etc fields cleared. And need listbox cleared of selections if any?
I think it is a different problem, so you need to start a new thread. And I suggest you provide a sample workbook and upload it to a free site such as dropbox.com & then put the link in the new thread.
I will help if I can.
 

Forum statistics

Threads
1,082,176
Messages
5,363,583
Members
400,752
Latest member
HamerTime7119

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top