miércoles, 28 de junio de 2023

EXCEL CONTROL DE FORMULARIO INTERACTIVO-SOLO APARECE EN LAS COLUMNAS INDICADAS EN LA POSION CALCULADA

 


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