Making A Particular Wooksheet Active
 

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?

Making A Particular Wooksheet Active
 

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?

Making A Particular Wooksheet Active
 

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?

Making A Particular Wooksheet Active
 

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?