Spin buttons

[JannetteChristie]

Hello,

I have a sheet with 12 spin buttons (created using ActiveX Controls) - On startup I want them all to be reset to zero but cannot seem to make it work, can anyone help please ?

 

[ashakantasharma]

Can you share a sample file ?

 

[JannetteChristie]

Can you share a sample file ?

The code behind each of the buttons as follows:

Private Sub Task1SB_Change()
If Range("F3").Value = "" Then Task1SB.Value = 0
Range("F3").Value = Task1SB.Value
'UpdateScoreToTempTable
End Sub

Private Sub Task2SB_Change()
If Range("F4").Value = "" Then Task2SB.Value = 0
Range("F4").Value = Task2SB.Value
'UpdateScoreToTempTable
End Sub

Private Sub Task3SB_Change()
If Range("F5").Value = "" Then Task3SB.Value = 0
Range("F5").Value = Task3SB.Value
'UpdateScoreToTempTable
End Sub

Private Sub Task4SB_Change()
If Range("F6").Value = "" Then Task4SB.Value = 0
Range("F6").Value = Task4SB.Value
'UpdateScoreToTempTable
End Sub