Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle Font Style Macro
That's helpful. My code now looks like this. Sub BackgroundToggle() Dim FontColor As Long Dim FontBold As Boolean FontColor = Selection.Font.Color FontBold = Selection.Font.Bold If Selection.Interior.ColorIndex = xlNone Then Selection.Interior.ColorIndex = 2 'white ElseIf Selection.Interior.ColorIndex = 2 Then Selection.Interior.ColorIndex = 35 'yellow ElseIf Selection.Interior.ColorIndex = 35 Then Selection.Interior.ColorIndex = 1 'black Selection.Font.Color = RGB(255, 255, 255) Selection.Font.Bold = True ElseIf Selection.Interior.ColorIndex = 1 Then Selection.Interior.ColorIndex = 48 'blue Selection.Font.Color = RGB(255, 255, 255) Selection.Font.Bold = True Else Selection.Interior.ColorIndex = xlNone Selection.Font.Bold = FontBold Selection.Font.Color = FontColor End If End Sub It's still not working. Even when the selection is not a mixed bag, i doesn't work. Any more ideas -- GK8053 ----------------------------------------------------------------------- GK80535's Profile: http://www.excelforum.com/member.php...fo&userid=1546 View this thread: http://www.excelforum.com/showthread.php?threadid=27213 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing font style and color using VBA | Excel Discussion (Misc queries) | |||
Change the Font Style in VBA | Excel Discussion (Misc queries) | |||
Toggle Font Style Macro | Excel Programming | |||
Toggle Font Style Macro | Excel Programming | |||
Toggle Font Style Macro | Excel Programming |