load a combo box with a list from name

[Aviad]

How can i load combox?

I have a list in a name: "Brandmanager" and i want my combobox to show her values.

How can i do it?

Aviad

 

[Trevor G]

Is the combo box on a userform if so then you need to look at the Initialise or Activate event then add something like this. Name the combo box something like cboNames

Private Sub UserForm_Activate()
Sheets("[COLOR=red]Sheet2[/COLOR]").Select
Range("[COLOR=red]b2[/COLOR]").Select
Do Until ActiveCell.Value = ""
    Me.cboNames.AddItem ActiveCell.Value
    ActiveCell.Offset(1, 0).Select
    
Loop
End Sub

 

[Norie]

Aviad

If 'Brandmanager' is a named range then you can use it to set the RowSource (or is it ListFillRange) property.

You can do that in design view, or in code.

CombBox1.RowSource = "Brandmanager"
 
' or
 
ComboBo1.List = Range("Brandmanager").Value