Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform initializing problem when opening | Excel Programming | |||
Initializing UserForm which uses MultiPage controls | Excel Programming | |||
stop userform from initializing | Excel Programming | |||
Initializing Combobox in a Userform | Excel Programming | |||
Initializing Userform | Excel Programming |