Initializing UserForm
 

'Hi,
I am working on a userform which references several cells on a worksheet
(called "Projects"). However, when I try toinitialise it from another
worksheet ("Timesheet") I get the following error message:

Run-time error 1004:
Select methos of Range class failed

Couls someone explain what this means please.

Ultimately, when the usrFrm has been completed I want to hide the "Projects"
worksheet and initailise the usrFrm from the "Timesheet" worksheet.

Many thanks.

CMcK

Initializing UserForm
 

You can't select on a hidden sheet - only on the activesheet.

You rarely need to select however

Userform1.Textbox1.Value = Worksheets("Projects").Range("B9").Value
Userform1.Textbox2.Value = Worksheets("Projects").Range("C11").Value

--
Regards,
Tom Ogilvy


"CMcK" wrote in message
...
'Hi,
I am working on a userform which references several cells on a worksheet
(called "Projects"). However, when I try toinitialise it from another
worksheet ("Timesheet") I get the following error message:

Run-time error 1004:
Select methos of Range class failed

Couls someone explain what this means please.

Ultimately, when the usrFrm has been completed I want to hide the
"Projects"
worksheet and initailise the usrFrm from the "Timesheet" worksheet.

Many thanks.

CMcK