hello
I linked spinbutton with combobox . it works when press next or previous into spinbutton . but the problem if I press next and ther is no next value and when return previous value it doesn't show from the first time . I have to rturn pressing twice to show the value as I did it when pressed next in first time is not existed next value . how can overcome this problem experts?
this the piece of code
I linked spinbutton with combobox . it works when press next or previous into spinbutton . but the problem if I press next and ther is no next value and when return previous value it doesn't show from the first time . I have to rturn pressing twice to show the value as I did it when pressed next in first time is not existed next value . how can overcome this problem experts?
this the piece of code
VBA Code:
Private Sub SpinButton1_Change()
On Error Resume Next
Me.cmb1.ListIndex = Me.SpinButton1.Value
End Sub