Reset spin button (form control) when new selection made from Combo box

[dashboardrookie]

Hi All,

I have tried searching numerous forums to help, on what I am hoping is an easy solution!

I am creating a dashboard and have a combo box driving cells in my dashboard. One of which is a cell which contains a summary of text.
I have created a spin button which allows you to scroll through the text as I have a limited space and would like the user to be able to scroll through all the text from the field.
This works great, however, when a new selection is picked from the combo box, the spin button value stays where it was last scrolled to.

Is there a way to reset the spin button to 0 each time a new selection is made in the combo box?

I have linked the Combo Box to C3 and spin button to A15. I have tried the below code, however it only works when I manually type a number in C3, it doesn't automatically change when the cell changes from the new selection.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("c3").Address Then
Range("a15").Value = ""
End If
End Sub

Thank you for your help!

 

[My Aswer Is This]

Try this:

Private Sub ComboBox1_Change()
SpinButton2.Value = 0
End Sub

 

[dashboardrookie]

Try this:

Private Sub ComboBox1_Change()
SpinButton2.Value = 0
End Sub

Thank you very much! Applied the Code to my Combo box and works great.

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Thank you very much! Applied the Code to my Combo box and works great.