Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am writing some code in a macro, that when a checkbox is checked, the macro
is run and will look at a cell to see if the word "TRUE" is in it. If it is true, I want to turn the cell red. If it is not true, I want the cell to be white. I am getting an else without if error. Below is the code, could someone help me? Sub us() ' ' us Macro ' Macro recorded 12/22/2005 by ' ' If Range("M42") = "True" Then ActiveWindow.SmallScroll Down:=4 Range("D42,D44,D46").Select Range("D46").Activate ActiveWindow.SmallScroll Down:=3 Range("D42,D44,D46,D48,D50").Select Range("D50").Activate With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic Else ActiveWindow.SmallScroll Down:=4 Range("D42,D44,D46").Select Range("D46").Activate ActiveWindow.SmallScroll Down:=3 Range("D42,D44,D46,D48,D50").Select Range("D50").Activate With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
visual basic | Excel Worksheet Functions | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Help with Visual Basic | Excel Programming | |||
Visual Basic | Excel Programming |