row source
 

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

row source
 

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


---
Regards,
Norman


"Zaahir" wrote in message
...
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