Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I from a UserForm bring up a particular wookboob sheet to enter data
in dependant upon the results of testing weather another wooksheets cell True or False condition, or Do I HAVE TO make these entries from a UserForm? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That's confusing. Post back and tell us what you have and what you want to
do. HTH Otto "Wmeyer2" wrote in message ... How do I from a UserForm bring up a particular wookboob sheet to enter data in dependant upon the results of testing weather another wooksheets cell True or False condition, or Do I HAVE TO make these entries from a UserForm? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Otto
That's confusing. I thought maybe it was just me<g Gord On Tue, 23 Mar 2010 18:31:59 -0400, "Otto Moehrbach" wrote: That's confusing. Post back and tell us what you have and what you want to do. HTH Otto "Wmeyer2" wrote in message ... How do I from a UserForm bring up a particular wookboob sheet to enter data in dependant upon the results of testing weather another wooksheets cell True or False condition, or Do I HAVE TO make these entries from a UserForm? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Not sure what you want Maybe: If Worksheets("FirstSheet").Range("A1").Value = TRUE then Worksheets("SecondSheet").Range("C3").Value = 7 end if this can be run in a sub without a Userform. A Userform would be needed if the User needs to pick the sheet name "FirstSheet" or "SecondSheet" from a list of sheets for example (or the value 7, or the range "C3" etc). regards Paul On Mar 23, 10:16*pm, Wmeyer2 wrote: How do I from a UserForm bring up a particular wookboob sheet to enter data in dependant upon the results of testing weather another wooksheets cell True or False condition, or Do I HAVE TO make these entries from a UserForm? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
making a different sheet active | Excel Programming | |||
Trouble making another worksheet active | Excel Programming | |||
Making an open workbook active | Excel Programming | |||
Summing a range without making it active | Excel Programming | |||
Making an active cell the first one to appear on the spreadsheet | Excel Programming |