Stephen Bullen wrote:

Setting the value of a check box does indeed fire the _Click event. Most
people get around this by using a 'mbNoEvents' module-level variable:

Dim mbNoEvents As Boolean

'In the spin button code:
mbNoEvents = True
CheckBox1.Value = True
CheckBox2.Value = False
mbNoEvents = False

Private Sub CheckBox1_Click()

If mbNoEvents then Exit sub

'... do whatever
End Sub

Many, many thanks for this. As it happens I'd worked something out on
the same lines embedded in the _click code but yours is a more elegant
solution.

Peter