How do I program in VBA some Excel behaviours like colored-cell-.

[Guest]

How do I program in VBA some Excel behaviours like colored-cell-borders
after pressing F2?

 

[Lonnie M.]

HI,
Place the following code in 'ThisWorkbook':
'########################################################
Sub Auto_Open()
Application.OnKey "{F2}", "myBorders"
End Sub
'########################################################

Insert a module and place the following code:
'########################################################
Public Sub myBorders()
On Error Resume Next
With Selection.Borders(xlEdgeLeft)
..LineStyle = xlContinuous
..Weight = xlThin 'xlMedium xlThick xlHairline
..ColorIndex = 15
End With
With Selection.Borders(xlEdgeTop)
..LineStyle = xlContinuous
..Weight = xlThin 'xlMedium xlThick xlHairline
..ColorIndex = 15
End With
With Selection.Borders(xlEdgeBottom)
..LineStyle = xlContinuous
..Weight = xlThin 'xlMedium xlThick xlHairline
..ColorIndex = 15
End With
With Selection.Borders(xlEdgeRight)
..LineStyle = xlContinuous
..Weight = xlThin 'xlMedium xlThick xlHairline
..ColorIndex = 15
End With
End Sub
'########################################################
HTH--Lonnie M.

 

[Guest]

If you could explain more precisely what you would like to do then I may be
able to help.

Exactly which behaviours do you wish to emulate?