I have a userform that has a Spin Button in it, and I am trying to hit a Command Button (or Label in this case) and make it run the SpinDown and then Another to run the SpinUp, but this doesn't appear to work.
Is this not possible?
My Spin Buttons look like this:
I tried this:Public Sub SpinButton1_SpinDown() 'SCAN FORWARD ShowCurrentRecord With New MSForms.DataObject .SetText TextBox1.Text .PutInClipboard End With End Sub Public Sub SpinButton1_SpinUp() 'SCAN BACKWARD ShowCurrentRecord With New MSForms.DataObject .SetText TextBox1.Text .PutInClipboard End With End Sub
andPrivate Sub Label14_Click() SpinButton1_SpinDown End Sub
Private Sub Label14_Click() UserForm1.SpinButton1_SpinDown End Sub
Thanks in advance for any help.
(Of you need the reasoning behind this, it is so I can use better visuals for my Spin buttons than the default ugly ones)





Reply With Quote