Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format using VBA not activating when needed
In the following procedure, how do I have the formatting occur as soon as
the operator exits the cell (either by the keyboard or mouse)? At the moment this procedure requires the operator to exit and then activate that cell again. Rob Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("K:K")) Is Nothing Then Exit Sub If Me.Cells(Target.Row, "K") = "" Then With ActiveCell.Offset(0, -10).Resize(1, 16).Interior .ColorIndex = xlNone End With End If If Me.Cells(Target.Row, "K") = "AH" Then With ActiveCell.Offset(0, -10).Resize(1, 16).Interior .ColorIndex = 45 .Pattern = xlSolid End With End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time format help needed | Excel Worksheet Functions | |||
Activating wrap text format causes my text to disappear, why? | Excel Discussion (Misc queries) | |||
IF / Else Format help needed | Excel Worksheet Functions | |||
Help needed to format x-axis of graph | Excel Discussion (Misc queries) | |||
Help needed with date format | Excel Discussion (Misc queries) |