object required

N

Nigel

OK this is where excel gets frustrating,

I have a spreadsheet with a user form on it and a button that open the form,
the code on the button is

riderinfo.show

works fine

I have another spreadsheet with the same type of setup on it and I get the
error message

Run time error 424

object required

why would one work and not the other


also I want to set the rowsource of a combo box to a spreadsheet called list

so in row source I have typed list!(A2:A4)

and get the error message Could not set the row source property. invalid
property value

some help would be appreciated

thanks
 
O

Office_Novice

Could you post then code for the cmmadbutton issue?

Here is the solution to your rowsouce

ComboBox1.RowSource = "list!A2:A4"
 
N

Nigel

entryform.show

Office_Novice said:
Could you post then code for the cmmadbutton issue?

Here is the solution to your rowsouce

ComboBox1.RowSource = "list!A2:A4"
 
O

Office_Novice

It should look somthing like this no?

Sub CommandButton1_Click() '<--you named button here of course
entryform.show
End sub

have you named your form entryform? I cant seem to recreate your error. Good
luck.
 

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

Top