Disabling one side of a Spinner

[Farback]

I have created an ActiveX Spinner (SpinButton1) with a range of 1 - 10. Is it possible to disable the "Up" side of the Spinner when 10 is reached and to disable the "Down" side when 1 is reached.

I realise that the Spinner will not go further than 1 or 10, but I just want the user to know that the limit has been reached.

 

[RoryA]

No, I'm afraid not.

 

[pgc01]

I just want the user to know that the limit has been reached.

Hi

You can use the SpinUp event to test the value of the Spin button against the Max value and issue a message in case the Max value has been reached.

 

[Datsmart]

Code would look similar to this:

Private Sub SpinButton1_SpinUp()
    If [F36].Value = 10 Then
        MsgBox "Can not go beyond the value of Ten."
    Else
        [F36].Value = [F36].Value + 1
    End If
End Sub

Private Sub SpinButton1_SpinDown()
    If [F36].Value = 1 Then
        MsgBox "Can not go below the value of 1."
    Else
        [F36].Value = [F36].Value - 1
    End If
End Sub

Change F36 to the cell you are changing.

 

[pgc01]

Or:

Private Sub SpinButton1_SpinUp()
 
If SpinButton1.Value = SpinButton1.Max Then MsgBox "You reached the Max"
End Sub