row source

[new]

Private Sub UserForm_Initialize()
ComboBox1.RowSource = "DATA 1!it3ATA 1!it4"
End Sub

error:
runtime error 380
could not set the rowsource property.Invalid property
value.

current:
"DATA 1!it3ATA 1!it4" are not empty.

Pls help.
Thanks

 

[jim c.]

combobox1.rowsource = 'data 1'!$IT$3:$IT$4

works for me... winxp excel2000

 

[jim c.]

sorry, forgot the ""
this is correct

ComboBox1.RowSource = "'DATA 1'!$IT$3:$IT$4"