|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Option Explicit
- Public WithEvents texb As MSForms.TextBox
- Private Sub texb_Change()
- Dim j As Integer, s
- With UserForm18
-
- s = 0
- For j = 91 To 193 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
-
- .Label222 = IIf(s = 0, "", s)
- s = 0
- For j = 92 To 194 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label223 = IIf(s = 0, "", s)
- s = 0
- For j = 93 To 195 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label224 = IIf(s = 0, "", s)
- s = 0
- For j = 94 To 196 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label225 = IIf(s = 0, "", s)
-
- s = 0
- For j = 95 To 197 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label226 = IIf(s = 0, "", s)
- s = 0
- For j = 96 To 198 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label227 = IIf(s = 0, "", s)
- s = 0
- For j = 97 To 199 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label228 = IIf(s = 0, "", s)
-
- s = 0
- For j = 98 To 200 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label229 = IIf(s = 0, "", s)
-
- s = 0
- For j = 99 To 201 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label230 = IIf(s = 0, "", s)
-
- s = 0
- For j = 100 To 202 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label231 = IIf(s = 0, "", s)
- s = 0
- For j = 101 To 203 Step 17
- s = s + Val(.Controls("textbox" & j))
- Next j
- .Label232 = IIf(s = 0, "", s)
- s = 0
-
-
-
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|