row source

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
'<<=============
 
Back
Top