Searchable Combobox in Excel Userform VBA

Question

Searchable Combobox in Excel Userform VBA

Muhammad Zahid 6

I am working on a management system in excel using userform
I want to make a searchable combobox where as i type all the list items having that spellings show in tha list and then with the down arrow i can select the required item when there are more than one items are showing in the list with selection of down arrow and by pressing enter that item should be selected
i am new in excel and as well as in vba
someone who can teach me step by step
Regards
Mahar Muhammad Zahid

Erin Ding-MSFT 4,476 Reputation points

2020-12-29T07:50:08.633+00:00

Hi @Muhammad Zahid ,

Please check if the answer given by HansV-7609 is helpful for you.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Erin Ding-MSFT 4,476 Reputation points

2021-01-05T08:16:20.883+00:00

@Muhammad Zahid

How is your issue going?
Have you checked the answer given by HansV-7609?

1 answer

Your answer

Erin Ding-MSFT 4,476 Reputation points

2020-12-29T07:50:08.633+00:00

Hi @Muhammad Zahid ,

Please check if the answer given by HansV-7609 is helpful for you.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Erin Ding-MSFT 4,476 Reputation points

2021-01-05T08:16:20.883+00:00

@Muhammad Zahid

How is your issue going?
Have you checked the answer given by HansV-7609?

Answer 1

HansV 966 MVP

A userform combo box will do that automatically for you.

Make sure that the items you want to see in the dropdown list are stored in a column on a worksheet, for example in A1:A20 on Sheet1.
The list should be sorted in ascending order.

In the Visual Basic Editor, select Insert > UserForm.
Activate the Toolbox.
Click on the Combo Box button to select it, then click on your userform.
In the Properties pane, set the RowSource to the address of the list - Sheet1!A1:A20 in the above example.
Set the ControlSource to the address of the cell that should be filled with the selected entry (if desired, otherwise leave the ControlSource empty)

That's all!

Michael Cavaggioni 1 Reputation point

2021-03-29T21:24:30.833+00:00

@HansV - I see you are a real excel master...great job

question - i'm new to coding - can't seem to figure out a simple code to add in a userform to have staff enter details in text box and have it entered into my spreadsheet.

thank you in advance

Gabriel Dzsurdzsa 6

HansV-7609's post is the answer. In case you wanted screenshots and code sample to go along with his solution.

excel-vba-combobox-to-query-and-insert

Private Sub ComboBox1_Change()

    With ThisWorkbook.Sheets("Sheet1")

        .Range("B1").value = ComboBox1.value

    End With

End Sub

Private Sub InsertButton_Click()

    With ThisWorkbook.Sheets("Sheet1")

        .Range("B1").value = ComboBox1.value

    End With

End Sub

Private Sub QueryButton_Click()

    With ThisWorkbook.Sheets("Sheet1")

        For Each cell In .Range("A1:A14")

            If cell.value = ComboBox1.value Then

                cell.Interior.Color = vbYellow

            End If

        Next cell

    End With

End Sub

Share via

Searchable Combobox in Excel Userform VBA

1 answer

Your answer