Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Changes a cells interior color to red when it is double-clicked
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
    Cancel As Boolean)
    Dim myColor As Integer
    Target.Interior.ColorIndex = 3
End Sub