Maybe this will give you some ideas:
http://www.contextures.com/xlDataVal02.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Todd Heiks" wrote:


"aqualibra" wrote in message
...
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.


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


.