Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Desde_X_1 As Single, Hasta_X_1 As Single, _
Desde_Y_1 As Single, Hasta_Y_1 As Single, _
Desde_X_2 As Single, Hasta_X_2 As Single, _
Desde_Y_2 As Single, Hasta_Y_2 As Single
Dim img As Shape
On Error Resume Next
For Each img In ActiveSheet.Shapes
If img.Type = 8 Then img.Delete
Next
If ActiveCell.Value <> "" Then
Range("J5").Value = ActiveCell.Value
Else
Range("J5").Value = "%"
End If
With ActiveCell
Desde_X_1 = .Left: Hasta_X_1 = .Left + .Width
Desde_Y_1 = .Top: Hasta_Y_1 = .Top + .Height
End With
With ActiveWindow
Desde_X_2 = .PointsToScreenPixelsX(Desde_X_1): Hasta_X_2 = .PointsToScreenPixelsX(Hasta_X_1)
Desde_Y_2 = .PointsToScreenPixelsY(Desde_Y_1): Hasta_Y_2 = .PointsToScreenPixelsY(Hasta_Y_1)
End With
If ActiveCell.Column = 4 Or ActiveCell.Column = 11 Then
ActiveSheet.Spinners.Add(Hasta_X_1 - 40, Int(Desde_Y_1), 24, 50).Select
With Selection
.Value = ActiveCell.Value
.Min = 0
.Max = 20
.SmallChange = 1
.LinkedCell = ActiveCell.Address
.Display3DShading = True
End With
ActiveCell.Activate
End If
If ActiveCell.Column = 5 Or ActiveCell.Column = 12 Then
ActiveSheet.Spinners.Add(Hasta_X_1, Int(Desde_Y_1), 24, 50).Select
With Selection
.Value = ActiveCell.Value
.Min = 0
.Max = 20
.SmallChange = 1
.LinkedCell = ActiveCell.Address
.Display3DShading = True
End With
ActiveCell.Activate
End If
End Sub

No hay comentarios:
Publicar un comentario