Wonder if someone can help me please. A colleague has a planning model with lots of code behind it that she had built by some consultants quite a while ago. Last week the model worked fine, but she has gone to use it today and on opening the model she is getting an error message that says "Compile Error - Method or Data member not found" and highlights .checkBox2 in the following code
Sub check_checkboxes()
If Sheet4.CheckBox2.Value + Sheet4.CheckBox3.Value + Sheet4.CheckBox4.Value + Sheet4.CheckBox5.Value + Sheet4.CheckBox6.Value + Sheet4.CheckBox7.Value = 0 Then
Sheet4.Cells(12, 11).Interior.ColorIndex = 3
Else
Sheet4.Cells(12, 11).Interior.ColorIndex = 43
End If
End Sub
I've had a look at the code and can't see anything wrong. The model was originally written in 2003 and we are now running 2010. I have checked with the IT guys and they don't believe there have been any patch updates over the weekend.
Anyone got any bright ideas?
Sub check_checkboxes()
If Sheet4.CheckBox2.Value + Sheet4.CheckBox3.Value + Sheet4.CheckBox4.Value + Sheet4.CheckBox5.Value + Sheet4.CheckBox6.Value + Sheet4.CheckBox7.Value = 0 Then
Sheet4.Cells(12, 11).Interior.ColorIndex = 3
Else
Sheet4.Cells(12, 11).Interior.ColorIndex = 43
End If
End Sub
I've had a look at the code and can't see anything wrong. The model was originally written in 2003 and we are now running 2010. I have checked with the IT guys and they don't believe there have been any patch updates over the weekend.
Anyone got any bright ideas?