|
楼主 |
发表于 2023-6-2 23:13
|
显示全部楼层
最后的学习心得发出来 供大家指正
- Option Explicit
- Public WithEvents TxtboxC As MSForms.TextBox
- Private Sub TxtboxC_Change()
- ClsStrConName = TxtboxC.Name '//记录那个控件获得了焦点
- mg = "Change 我是: " & TxtboxC.Name
- MsgBox mg
- End Sub
- Private Sub TxtboxC_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
- ClsStrConName = TxtboxC.Name '//记录那个控件获得了焦点
- mg = "DblClick 我是: " & TxtboxC.Name
- MsgBox mg
- End Sub
- Rem Click可以用MouseUP事件替代
- Private Sub TxtboxC_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
- If ClsStrConName <> "" Then
- Rem 使用一个全局变量 记录最后操作的控件名
- Rem 可以变向实现事件Exit
- mg = " Exit 刚在是: " & ClsStrConName
- MsgBox mg
- End If
- ClsStrConName = TxtboxC.Name '//记录那个控件获得了焦点
- mg = " MouseUP 我是: " & TxtboxC.Name
- MsgBox mg
- End Sub
-
- 'Rem enter可以用KeyDown替代
- 'Private Sub TxtboxC_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
- ' If KeyCode = 13 Then
- ' mg = "KeyDown 我是: " & TxtboxC.Name
- ' MsgBox mg
- ' End If
- 'End Sub
- Rem Exit可以用KeyDown替代 注意: 不支持鼠标移动导致的退出文本框
- Private Sub TxtboxC_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
- If KeyCode = 13 Then
- ClsStrConName = TxtboxC.Name '//记录那个控件获得了焦点
- mg = "enter 我是: " & TxtboxC.Name
- MsgBox mg
- End If
- If KeyCode = 9 Then
- ClsStrConName = TxtboxC.Name '//记录那个控件获得了焦点
- mg = "Tab 我是: " & TxtboxC.Name
- MsgBox mg
- End If
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|