Option ExplicitDim IsNonEvents As BooleanPrivate Sub CheckBox1_Click() IsNonEvents = True CheckBox2.Value = CheckBox1.Value CheckBox3.Value = CheckBox1.Value IsNonEvents = FalseEnd SubPrivate Sub CheckBox2_Click() If IsNonEvents Then Exit Sub End If 'some codeEnd SubPrivate Sub CheckBox3_Click() If IsNonEvents Then Exit Sub End If 'some codeEnd Sub
Me.Controls("cb" & i & j) = FALSE
Sub ww()ActiveSheet.OLEObjects("CheckBox1").Object.Value = Not ActiveSheet.OLEObjects("CheckBox1").Object.ValueEnd Sub
Const OBJ_COLUMN As Long = 8 число столбцовConst OBJ_ROW As Long = 1 'число строкConst CTL_HEIGHT As Long = 20Const CTL_WIDTH As Long = 50Private Sub ForForm() Dim r As Integer, c As Integer, o As Object, q As Object myForm.Show Set o = myForm For r = 1 To OBJ_ROW For c = 1 To OBJ_COLUMN Set q = o.Controls.Add("Forms.CheckBox.1", "cb" & r & c) q.Caption = "cb" & r & c q.Left = CTL_WIDTH * c q.Top = CTL_HEIGHT * r q.SpecialEffect = 0 Next c Next rEnd SubPrivate Sub ForList()Dim r As Integer, c As Integer, o As ObjectFor r = 1 To OBJ_ROW For c = 1 To OBJ_COLUMN Set o = ActiveSheet.OLEObjects.Add("Forms.CheckBox.1") With o .Name = "cb_" & r & c .Object.SpecialEffect = 0 .Left = CTL_WIDTH * (c - 1) .Top = CTL_HEIGHT * (r - 1) .Width = CTL_WIDTH .Height = CTL_HEIGHT .Visible = True .Object.Caption = "cb" & r & c End With Next cNext rEnd Sub
With .Controls.Add("Forms.OptionButton.1") .Left = 1 .Top =1 .Width = 1 .Height = 1 .Name = "optBtn2" End WithMe.Controls("optBtn2").Value = Not Me.Controls("optBtn2").Value