If/then/else code for check boxes in Excel

[Guest_imported]

hi,

I'm trying to code check boxes in Excel to assign one value if they're checked and another if they are not. Here's what I got:

If Worksheets("Sheet1&quot.CheckBoxes(1) = True Then
M = 1
Else
M = 0
If Worksheets("Sheet1&quot.CheckBoxes(2) = True Then
T = 1
Else
T = 0

don't know where the problem is, but Excel doesn't like the code and goes to the "else" part whether it's true or not.

Help!

 

[Goska]

This works. I set it as an OnClick for a button of the sheet, and my check boxes are named CheckBox1 and CheckBox2.

It returns the proper values to cells A1 and A2.

Sub stuff()
Dim M As Integer
Dim T As Integer

If (Worksheets("Sheet1&quot.CheckBox1 = True) Then
M = 1
Else
M = 0
End If
If (Worksheets("Sheet1&quot.CheckBox2 = True) Then
T = 1
Else
T = 0
End If

Range("a1&quot.Select
ActiveCell = M
Range("a2&quot.Select
ActiveCell = T

End Sub

 

[SteveR321]

gfdgsdfg,

You forgot to put in the 'End If's

Steve