SPINBUTTON RIGHT TO LEFT

[GAVIOTA ONE]

good evening everybody ..forum.members.and moderators.
I'm so happy to join you in this great and best forum.


in my first discussion

I head you are hoping to solve my little problem
because of a small job I want the spinbutton walking from right to left
I have two file. in the first file spinbutton walking from right to left.
I want to adapt this spinbutton code in the workbook number 2 for the spinbutton also works as file number 1 from right to left
thank you in advance
cordially
GAVIOTA
13565

[SamT]

I don't understand the problem/issue..

Both codes should work in either workbook. As Long as all the ranges and UserForm controls are named to suit the code.

[GAVIOTA ONE]

I don't understand the problem/issue..

Both codes should work in either workbook. As Long as all the ranges and UserForm controls are named to suit the code.

hiiiii SamT
thank you for help
I want to reverse the direction of spinbutton in this workbook 2
see please
please see the picture
thank you
cordially
gaviota

[p45cal]

like this?
(just used the same techniques as in your first file; added a dynamic range name (Noms) and tweaked code from that file)

[GAVIOTA ONE]

like this?
(just used the same techniques as in your first file; added a dynamic range name (Noms) and tweaked code from that file)

Hiiii p45cal
thank you very much
thank you very much for this great pleasure
it's perfect for your part
it's so much I want
it is resolved
thank you
cordially
GAVIOTA
(((is what I can find a code spinbutton right to left that I can use and I can adapt to all userforms ??)))

[SamT]

Use SpinbuttonReverseValue to go in opposite direction

SpinButtonReverseValue = Spinbutton.Max - SpinButton.Value

Put this code in a Module, then call it in any UserForm

Function SpinButtonReverseValue(FormSpinButton As UserForms.SpinButton) As Integer
SpinButtonReverseValue = FormSpinButton.Max - FormSpinButton.Value
End Function
Example from SpinButton2.xlsm

If SpinButtonReverseValue(Me.SpinButton1) = cl Then

[GAVIOTA ONE]

Use SpinbuttonReverseValue to go in opposite direction

SpinButtonReverseValue = Spinbutton.Max - SpinButton.Value
hiiii SamT
I tried and it does not work with me.
thank you for help and adapt in this workbook
13568

[SamT]

I edited my post. try again
Change the Max Property on the Spinbutton.

[GAVIOTA ONE]

I edited my post. try again
Change the Max Property on the Spinbutton.

please master
I am newbie in vba excel
if you make me happy and put me your code in this workbook to better understand you
thank you in advance for your patience
13569

[SamT]

New Code in UserForm and in Module 1

[GAVIOTA ONE]

New Code in UserForm and in Module 1
thank you master SamT
thank you a lot
now it is solved
thank you again
it's beautiful work and beautiful code of your hand
cordially
GAVIOTA