I'd be tempted to hold the scope in a separate sheet and load the contents into the combo box when loading, this makes it easy to add additional scopes:
so if your list was in column A in Sheet2
New scopes could then be added as below:![]()
ContextOfUseComboBox.List = Sheet2.Range("A1").CurrentRegion.Value
![]()
Sheet2.Range("A1").End(xlDown).Offset(1, 0).Value = me.ContextOfUseComboBox.Text
Bookmarks