row source

[Guest]

Hi

I have a combobox on a userform.

frmMain.cmb1.RowSource = CustomerInfo

this code returns an error msg "Could not set rowsource, invalid property
value"

how do i set the rowsource correctly?

thanx

 

[Norman Jones]

Hi Zaahir,

The RowSource property requires a string.

What is CustomerInfo?

If CustomerInfo is a range name, try something like:

'=============>>
Private Sub UserForm_Initialize()
Me.ComboBox1.RowSource = _
Range("CustomerInfo").Address(External:=True)
End Sub
'<<=============