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

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

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

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.

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

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?

"TEXNAC" wrote:

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