Selección de celdas con spinbutton

[semovan]

Hola: necesito con spinbutton seleccionar diferentes celdas. Posteriormente, con otro spinbutton, incrementar o disminuir los valores de la celda seleccionada. Agradecido-

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

Lo sentimos , no hablo español.

Add two ActiveX SpinButtons to the worksheet.

Then add this code to the Worksheet module:

Private Sub SpinButton1_Change()
    Range("A1").Offset(SpinButton1.Value, 0).Select
End Sub

Private Sub SpinButton1_GotFocus()
    Range("A1").Offset(SpinButton1.Value, 0).Select
End Sub

Private Sub SpinButton2_Change()
    Range("A1").Offset(SpinButton1.Value, 0).Value = SpinButton2.Value
End Sub

It may get you started.

Regards,

 

[semovan]

Thanks RickXL, excuse me language, the next I will write in English.

 

[RickXL]

No problem.

Regards,