Excel 做得到在A1輸入1,B1顯示1然後換行清除1數據,A1再輸入2,B2顯示2換行?

2016-03-07 8:04 pm

回答 (1)

2016-03-08 4:23 am
✔ 最佳答案
插入一個TextBox ActiveX 控制項

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 13 Then
If Cells(1, 2) = "" Then
Cells(1, 2) = TextBox1
Else
Cells([B65536].End(xlUp).Row + 1, 2) = TextBox1
End If
TextBox1 = ""
End If
End Sub


收錄日期: 2021-05-04 02:06:06
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160307120414AAJsTQ9

檢視 Wayback Machine 備份