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
|