Thread: Spin button
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Spin button

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.
--
If the post is helpful, please consider donating something to an animal
charity on my behalf.


"aqualibra" wrote:

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.