¥»©«³Ì«á¥Ñ av8d ©ó 2012-7-25 18:43 ½s¿è
- Set d = CreateObject("Scripting.Dictionary")
- d("GAS1") = "A"
- d("GAS2") = "B"
- d("GAS3") = "C"
- d("GAS4") = "D"
- d("GAS5") = "E"
- d("GAS6") = "F"
- d("GAS7") = "G"
- d("GAS8") = "H"
- d("GAS9") = "I"
- d("GAS10") = "J"
- d("GAS11") = "K"
- d("GAS12") = "L"
- d("GAS13") = "M"
- d("GAS14") = "N"
- d("GAS15") = "O"
- d("GAS16") = "P"
- d("GAS17") = "Q"
- d("GAS18") = "R"
- L1C = Label1.Caption
- L2C = Label2.Caption
- L3C = Label3.Caption
- L4C = Label4.Caption
- TB1 = TextBox1.Value
- '¸ê®ÆÂà´«
- For i = 1 To 18
- If Me.Controls("OptionButton" & i).Value = True Then
- If i = 1 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 2 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 3 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 4 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 5 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 6 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 7 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 8 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 9 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 10 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 11 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 12 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 13 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 14 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 15 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 16 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 17 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
-
- If i = 18 Then
- Sheets("ÂIÀ\").Cells(Rows.Count, "A").End(3)(2, 1).Resize(1, 7) = Array(L1C, L2C, L3C, L4C, 1, d("GAS" & i), TB1)
- End If
- End If
- Next i
½Æ»s¥N½X |