Combo Box items

[LiLi1]

I currently have a Combo Box on a user form and with-in the properties of the ComboBox I have the RowSource set to 'My Sheet'!A15:A21

this works perfectly ... they choose a value ... this value is called individualNameEntry and is used downstream.

My problem is that they want the names from MySheet in cells A25 until the last entry (usually about A90 to A115) to now show up in the ComboBox as a choice in addition to the current allowed A15:A21.

I tried changing the RowSource to 'My Sheet'!A15:A21;MySheet'!A25:A115 and a few other options but nothing worked I kept getting error messages.

This seems like it would be a fairly easy change but no luck so far...as always thanks so much in advance!

[ker9]

You can define a range and use the named range in the source of the combo box.
Sorry,that won't work, I misunderstood your question.

[LiLi1]

I don't know how to define a range where the list isn't static... i.e. the ending cell with-in the range wouldn't always be the same cell at any given moment in time when the file is opened.

The 2nd range would however always start at A25

[royUK]

Create the range to populate the ComboBox when the form loads

Please Login or Register  to view this content.

[LiLi1]

Thanks everyone... I used the idea to Initialize the form with code to populate the combo box as opposed to using the row source property and it works great! At first I kept getting error messages about permissions but I still had the original data in the row source property box. I needed to delete that completely to get the code to fill the combo box.