Excel VBA ¥Îtextbox·s¼Wªí³æ¸ê®Æ°ÝÃD
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
- Option Explicit
- Public n As Integer
- Private Sub CommandButton1_Click()
- If TextBox2.Value > 60 Then n = 20 Else n = 2
- Do
- If Cells(n, "B") = "" Then Exit Do
- n = n + 1
- Loop
- Sheets("Sheet1").Cells(n, "B").Value = TextBox1.Value
- Sheets("Sheet1").Cells(n, "C").Value = TextBox2.Value
- End Sub
½Æ»s¥N½X |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|