Another spinner question

[roscoe]

I have one cell, B4, that tells me how many "somethings" I can have. Cell B6 is where the user picks which "something" to use, min=1 and max=the value of B4.

How can I build a spin button where the user can just cycle from 1,2,3,...max where the max is not fixed?

Thanks!

Roscoe

 

[roscoe]

OK, I constructed the following code by plagiarizing from some similar code I found elsewhere, but it's giving me a bizarre error message (and I'm not even sure if this should work):

Private Sub SpinButton6_Change()
Dim Slice_to_edit As Range

Set Slice_to_edit = Worksheets("Data").Range("Slice_to_edit")
    If SpinButton6 > 0 And SpinButton6 < 5 Then
        Slice_to_edit.value = SpinButton6
    End If
End Sub

The named range "Slice_to_edit" is the value in cell B6 I want to roll with the spinner. But when I click on the spin button I get "compile error: procedure declaration does not match description of event or procedure having the same name"

Note I hard coded the maximum value 5 for testing but it really needs to reference the value in cell B4. NOt worried about that yet, just wnat to see if this can work

No clue what this means (No, I don't have another procedure with the same name)...

 

[roscoe]

Disregard. Got it to work.