怎樣簡化以上程序?
If s1 = False Then
Shape1(0).FillColor = vbGreen
Else: Shape1(0).FillColor = vbRed
End If
If s2 = False Then
Shape1(1).FillColor = vbGreen
Else: Shape1(1).FillColor = vbRed
End If
If s3 = False Then
Shape1(2).FillColor = vbGreen
Else: Shape1(2).FillColor = vbRed
End If
If s4 = False Then
Shape1(3).FillColor = vbGreen
Else: Shape1(3).FillColor = vbRed
End If
If s5 = False Then
Shape1(4).FillColor = vbGreen
Else: Shape1(4).FillColor = vbRed
End If
If s6 = False Then
Shape1(5).FillColor = vbGreen
Else: Shape1(5).FillColor = vbRed
End If
If s7 = False Then
Shape1(6).FillColor = vbGreen
Else: Shape1(6).FillColor = vbRed
End If
If s8 = False Then
Shape1(7).FillColor = vbGreen
Else: Shape1(7).FillColor = vbRed
End If
If s9 = False Then
Shape1(8).FillColor = vbGreen
Else: Shape1(8).FillColor = vbRed
End If
If s10 = False Then
Shape1(9).FillColor = vbGreen
Else: Shape1(9).FillColor = vbRed
End If
If s11 = False Then
Shape1(10).FillColor = vbGreen
Else: Shape1(10).FillColor = vbRed
End If
If s12 = False Then
Shape1(11).FillColor = vbGreen
Else: Shape1(11).FillColor = vbRed
End If
If s13 = False Then
Shape1(12).FillColor = vbGreen
Else: Shape1(12).FillColor = vbRed
End If
If s14 = False Then
Shape1(13).FillColor = vbGreen
Else: Shape1(13).FillColor = vbRed
End If
If s15 = False Then
Shape1(14).FillColor = vbGreen
Else: Shape1(14).FillColor = vbRed
End If
If s16 = False Then
Shape1(15).FillColor = vbGreen
Else: Shape1(15).FillColor = vbRed
End If
If s17 = False Then
Shape1(16).FillColor = vbGreen
Else: Shape1(16).FillColor = vbRed
End If
If s18 = False Then
Shape1(17).FillColor = vbGreen
Else: Shape1(17).FillColor = vbRed
End If
If s19 = False Then
Shape1(18).FillColor = vbGreen
Else: Shape1(18).FillColor = vbRed
End If
If s20 = False Then
Shape1(19).FillColor = vbGreen
Else: Shape1(19).FillColor = vbRed
End If
請教各位大俠. 怎樣簡化以上程序?