Spinbutton to select values from list

[Jagat Pavasia]

hi ,
I have number in cell from C6 to C2500. something like 255, 240.50, 266.67, 312.25, 20.10 etc.

I had insert spin tool from developer and i want to spin only this number in my A1 cell.

so what i do ?




this is image of my worksheet

https://ibb.co/3r9pQCJ

 

[Yongle]

I think you are using Form Control Spin Button

Right-click on the Spinner \ select Format Control \ Cell Link value should be A1

Clicking on spinner changes value in A1

 

[Jagat Pavasia]

dear Yongle,
yes, i am using form control spin button, but i want spin digit from my C6 to C2500.

just think that if my C6=25 ,C7=100, C8=100, C9=25, C10=25, C11=100, then if i spin 1 time then result should be in A1 is 25 and another spin result should be 100

 

[Yongle]

One way
- ROW number in cell B1 and make the spin button change that value

Formula in A1
=INDEX(A1:A2500,B1)

Spin Button format control settings
- Link cell is B1
- Minimum value = 6
- maximum value = 2500
- incremental change = 1

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

100​

[/td][td=bgcolor:#C6E0B4]

7​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td=bgcolor:#FFFF00]

25​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td=bgcolor:#FFFF00]

100​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td=bgcolor:#FFFF00]

100​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td=bgcolor:#FFFF00]

25​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td=bgcolor:#FFFF00]

25​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td=bgcolor:#FFFF00]

100​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td=bgcolor:#FFFF00][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td=bgcolor:#FFFF00][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td=bgcolor:#FFFF00][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td=bgcolor:#FFFF00][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td=bgcolor:#FFFF00][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet4[/td][/tr][/table]

 

[Jagat Pavasia]

This is working but i did not want this type,

i want that if i spin up button one time then result should be 25 and second spin result should be 100.

You guide me that all raw number of raw display

 

[Yongle]

I think I gave you what you asked for. I have read again everything written in your posts.

What is it doing that you do not want?
What is it not doing that you do want?

 

[Jagat Pavasia]

in your reply C6 to C11 have number of 25 & 100, so i want only this number in spin.
Means when i spin once than it should shows 25 and after spin shown 100 and third spin shown 25.

If i had written 25, 100, 125, & 150, then it should be only spin this 4 digit. ( do not repeat same number)

 

[Yongle]

this is what you said in post#3

just think that if my C6=25 ,C7=100, C8=100, C9=25, C10=25, C11=100,
then if i spin 1 time then result should be in A1 is 25 and another spin result should be 100

Solution in post#4 gives these results:

Cell C6 25
after Spin 1, A1 = 25

Cell C7 100
after Spin 2, A1 = 100

Cell C8 100
after Spin 3, A1 = 100

Cell C9 25
after Spin 4, A1 = 25

Cell C10 25
after Spin 5, A1 = 25

Cell C11 100
after Spin 6, A1 = 100

this is what you said in post#7

If i had written 25, 100, 125, & 150, then it should be only spin this 4 digit. ( do not repeat same number)

Is this what want?

Cell C6 25
after Spin 1, A1 = 25

Cell C7 100
after Spin 2, A1 = 100

IGNORE Cell C8 100 (same as previous spin)

Cell C9 25
after Spin 3, A1 = 25

IGNORE Cell C10 25 (same as previous spin)

Cell C11 100
after Spin 4, A1 = 100

 

[Jagat Pavasia]

I want that do not repeat same number .

cell C6 25
cell c7 100
cell c8 25
cell c9 25
cell c10 99

i want that if i spin first time then result 25 then 100 then 99.

(do not repeat same number)

did you understand ?

 

[Yongle]

Yes, I understand what you want