Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Macro
I have an Excel workbook which naviagates from sheet to sheet using a
control button to move to the next sheet in the workbook. How can I program the macro attached to the control button so that if condition X (False) is met, one moves to sheet A ("Insulin Rate"), but if condition Y (True) is met, one moves to sheet B ("Prev Gluc 2")? This is what I've tried thus far: If ("G1") = False Then Sheets("Insulin Rate").Activate Range ("C3").Activate ElseIf ("G1") = True Then Sheets("Prev Gluc 2").Activate Range ("C3").Activate EndIf I've also tried using .Select instead of .Activate, but that doesn't work either. Appreciate your help. -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
If Range("G1").Value = False Then
Sheets("Insulin Rate").Activate Range ("C3").Activate ElseIf Range("G1").Value = True Then Sheets("Prev Gluc 2").Activate Range ("C3").Activate EndIf -- HTH RP (remove nothere from the email address if mailing direct) "Shelley Shepherd via OfficeKB.com" wrote in message ... I have an Excel workbook which naviagates from sheet to sheet using a control button to move to the next sheet in the workbook. How can I program the macro attached to the control button so that if condition X (False) is met, one moves to sheet A ("Insulin Rate"), but if condition Y (True) is met, one moves to sheet B ("Prev Gluc 2")? This is what I've tried thus far: If ("G1") = False Then Sheets("Insulin Rate").Activate Range ("C3").Activate ElseIf ("G1") = True Then Sheets("Prev Gluc 2").Activate Range ("C3").Activate EndIf I've also tried using .Select instead of .Activate, but that doesn't work either. Appreciate your help. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get simple macro to run | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions |