C
CG Rosén
Good Evening Group,
On my UserForm there is a ComboBox linked to a SpinButton by below code:
Private Sub ComboBox1_Change()
NewVal = Val(ComboBox1.Value)
If NewVal >= SpinButton1.Min And _
NewVal <= SpinButton1.Max Then _
SpinButton1.Value = NewVal
End Sub
Is it possible to determine if the ComboBox value is manipulated by the
SpinButton or
if the ComboBox value has has been "manually" inserted?
Brgds
CG Rosén
On my UserForm there is a ComboBox linked to a SpinButton by below code:
Private Sub ComboBox1_Change()
NewVal = Val(ComboBox1.Value)
If NewVal >= SpinButton1.Min And _
NewVal <= SpinButton1.Max Then _
SpinButton1.Value = NewVal
End Sub
Is it possible to determine if the ComboBox value is manipulated by the
SpinButton or
if the ComboBox value has has been "manually" inserted?
Brgds
CG Rosén