Using VBA to create a dynamic Combo box population

[Imma1313]

I’m trying to create a user form for a log that allows the user to select a document within a log and edit other cells along that same row.

The log will continue to grow, so I need to be able to use the combobox to select the document number for editing items along that row. Log will start with number 1 and will increase as it progresses. There are two summary lines starting two rows beneath the first row of data, and I do not want to include these rows in the combo box list.

 

[sxhall]

Are you looking something like this? My data in yellow is added to the combobox when the form is opened.

This code starts in cell B3 and captures all the cells in yellow and no more. Will capture as new rows are added to the list so if 6 is added in row 8 it then captures it as well. This goes in the userform code and will run as soon as the userform is opened, 'on intitialize', without having to do anything else.

Private Sub UserForm_Initialize()

ComboBox1.List = Range(Sheet1.Range("B3"), Sheet1.Range("B3").End(xlDown)).Value

End Sub

If you can add in a screenshot of your spreadsheet, removing anything sensitive of course, and highlight what you would like to be in the combobox.