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

dashboardrookie

New Member
Joined
Aug 19, 2016
Messages
2
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.

Code:
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!
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,761
Office Version
2013
Platform
Windows
Try this:

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

Watch MrExcel Video

Forum statistics

Threads
1,099,075
Messages
5,466,468
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top