Command Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a command button on Sheet 1. I want a user to go to Sheet 2 if value
in L4 = 0, Sheet 3 if value in L4 = 2, Sheet 4 if value in L4 = 4.

How do I do this?

THK in Advance
 
try to introduce this code under command button code

If Sheet1.Range("L4") = 0 Then Sheet2.Activate
If Sheet1.Range("L4") = 2 Then Sheet3.Activate
If Sheet1.Range("L4") = 4 Then Sheet4.Activate

see whether you get what you want
====================
 
You must log in or register to reply here.

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

Run-time error 1004 paste method of worksheet class failed 3
condtional format - hightlight max results 4
very repetive formula needs looking at 7
Comparing Dates in 4 Columns - Nested Formulas? 2
count data from one sheet to another 4
ignore cells that are blank 4
nested if 3
Macro is very slow 2

Back
Top