Spin button

  • Thread starter Thread starter aqualibra
  • Start date Start date
A

aqualibra

I am using multiple spin buttons in my file.

For eg: Spin button 1 has options 1, 2, 3, 4, 5
Spin button 2 has options 1, 2, 3, 4, 5

If option 1 has been selected for spin button 1 then spin button 2 can be 2,
3, 4, 5
If spin button 1 = 2 then spin button 2 cannot = 2 and so forth.

Is this possible??

Thanks.
 
aqualibra said:
I am using multiple spin buttons in my file.

For eg: Spin button 1 has options 1, 2, 3, 4, 5
Spin button 2 has options 1, 2, 3, 4, 5

If option 1 has been selected for spin button 1 then spin button 2 can be
2,
3, 4, 5
If spin button 1 = 2 then spin button 2 cannot = 2 and so forth.

Is this possible??

Thanks.
Click to expand...
 
aqualibra said:
I am using multiple spin buttons in my file.

For eg: Spin button 1 has options 1, 2, 3, 4, 5
Spin button 2 has options 1, 2, 3, 4, 5

If option 1 has been selected for spin button 1 then spin button 2 can be
2,
3, 4, 5
If spin button 1 = 2 then spin button 2 cannot = 2 and so forth.

Is this possible??

Thanks.
Click to expand...


Does this work?
Private Sub sb1_SpinDown()
If sb1.Value = sb2.Value Then
If sb1.Value = 0 Then
sb1.Value = Max
Else
sb1.Value = sb2.Value - 1
End If
End If
TB1.Value = sb1.Value

End Sub
 
I think you have two options :

1. Instead of using a spinner, use listboxes and populate one from the
selection made in the other.

2. Use two pictures (obviously one for up and one for down) for each
spinner that can be backed by code which will populate your target cells,
thus avoiding items that have already been selected

I would recommend the former option.
 
Back
Top