row source

  • Thread starter Thread starter new
  • Start date Start date
N

new

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

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

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

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

works for me... winxp excel2000
 
sorry, forgot the ""
this is correct

ComboBox1.RowSource = "'DATA 1'!$IT$3:$IT$4"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate combobox 6
Error 380 4
still get runtime error 424 9
Row source question. 17
Excel keeps shutting down using code 2
list box remove item by combobox 4
My macro doesn't work if sheet is protected but it works if not protected 2
RowSource 4

Back
Top