Command Button
 

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
====================

Chris Hale wrote in message
...
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