setting vairable rowsource property

[chiplonkar]

I have an user form with a combobox. I want to set the dropdown list. If I set it through the properties of the combobox, it is a fixed length dropdown list. i.e. combobox2.rowsource="A1:A18" has eighteen cells in coumn "A". I want to make the figure 18 as a variable depending upon the number of entries in the column A. I tried combobox2.rowsource="A1:A&m"
wher m is an integer varibale. It does not work. Can anyone suggest the correct syntax?

 

[AlphaFrog]

Hi and welcome.

Here is one way it could be done.

Private Sub UserForm_Initialize()

    Dim cell As Range
    
    ComboBox1.RowSource = ""
    ComboBox1.Clear
    
    With Sheets("Sheet1")
        For Each cell In .Range("A1", .Range("A" & Rows.Count).End(xlUp))
            ComboBox1.AddItem cell.Value
        Next cell
    End With
    
End Sub

 

[chiplonkar]

Great! It worked !! Thank you very much. I think you have faced this situation of having a variable length of dropdown earlier !! Thanks again.