VBA: fill combobox from a column Solved

Question

Hello,

I want to fill the combo box in the userform from a column and I am using this code

 Private Sub UserForm_Initialize() Dim i As Long For i = 2 To 20 ComboBox1.AddItem Sheets("ListOfParameters").Cells(i, 1) Next i UserForm1.Show End Sub

There is an 'Object required' error that appears, I don't understand the cause of this error

Thank you for your help
Best,
Alena
Configuration: Windows 7 / Internet Explorer 9.0

eriiic · Accepted Answer

Hello,  or: Private Sub UserForm_Initialize() ComboBox1.List = worksheets("Sheet1").Range("A2:A20").Value End Sub eric  -- You will never respond to an unsolicited DM... Well, that's done.

f894009 · Answer

Hello, When you have the error, click on debugging: which line does the program stop at?????

pijaku · Answer

Hello,  Try this:  Private Sub UserForm_Initialize() Dim i As Long With Sheets("ListOfParameters") For i = 2 To 20 ComboBox1.AddItem .Cells(i, 1) Next i End With End Sub   Best regards, Franck P

alena20 · Answer

Thank you Eric, but the problem persists. Where should I place the code, in ThisWorkbook or Module?

alena20 · Answer

Hello,  Thank you for all your attempts. Here is the document that might help us https://www.cjoint.com/?BKinIGi8Hph  Best, Alena

alena20 · Answer

Thank you all. The mistake was that I had put the code in the module when it needed to go in the userform code.

VBA: fill combobox from a column

6 answers

Problem importing contacts

Takara kdv103b dvd player remote control

What address is my account at?

Copy the formatting of one cell to another cell

Ancient sky

Non-hp cartridges

Yahoo not replying

Find the cloud

Hardening cpu kernel?

Unable to change avatar