Userform - add new item to combobox drop down list

windwardmi

Board Regular
Joined
Oct 18, 2009
Messages
138
I have a userform ComboBox that pulls drop down list from Col A of another sheet in workbook.

This list in Col A is constantly added to manually. i.e. I have new clients to add.

How can I avoid adding new clients manually in order to show up when using the userform ComboBox. What code can I add to the ComboBox to select an item in drop down list to add new client to Col A in other sheet. If I do not need to add new client I still want to see present list of clients in Col A in other sheet.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Please never use the term "Other Sheet" when asking for help

Please give the name of the sheet.
Please give the name of the ComboBox on your UserForm

So are you saying you want to see all the values in Column A of sheet named "Alpha" in your ComboBox ?
When your UserForm is opened.
 
Upvote 0
If the answer to my previous question is yes then add this script to your UserForm
Code:
Private Sub UserForm_Initialize()
'Modified  7/16/2019  6:05:20 PM  EDT
Dim Lastrow As Long
Lastrow = Sheets("Alpha").Cells(Rows.Count, "A").End(xlUp).Row
ComboBox1.List = Sheets("Alpha").Range("A1:A" & Lastrow).Value
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top