Cómo hacer una macro para poner una palomita
Y ahí les va el código, por si lo quieren copiar y pegar.
Sub FlechaVerde()
Selection.FormulaR1C1 = "ü"
With Selection.Font
.Name = "Wingdings"
.Size = 12
.Color = -13402799
.TintAndShade = 0
End With
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Interior.Color = 13954269
End With
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlDouble
.ThemeColor = 10
.TintAndShade = -0.249946592608417
.Weight = xlThick
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlDouble
.ThemeColor = 10
.TintAndShade = -0.249946592608417
.Weight = xlThick
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlDouble
.ThemeColor = 10
.TintAndShade = -0.249946592608417
.Weight = xlThick
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlDouble
.ThemeColor = 10
.TintAndShade = -0.249946592608417
.Weight = xlThick
End With
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
End Sub

Leave a Reply