Making A Particular Wooksheet Active

W

Wmeyer2

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?
 
O

Otto Moehrbach

That's confusing. Post back and tell us what you have and what you want to
do. HTH Otto
 
P

Paul Robinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering data from a userform into multiple sheets 2
ReturnBoolean??? 2
Making a field compulsary before user leaves sheet 3
Dependant ComboBox on a UserForm 1
Saving in VBA to a particular location 3
Userform - need to access data from a particular sheet 2
Option buttons not responding 6
Problem with SET & REF function 0

Top