- UID
- 947
- 帖子
- 2538
- 积分
- 12937
- 阅读权限
- 70
- 注册时间
- 2005-7-11
- 最后登录
- 2014-11-5
- 在线时间
- 2733 小时
|
你是否应该这样做:
Dim myExcel As New Excel.Application()
Dim WithEvents MyBook As Excel.Workbook
.......
Private Sub MyBook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) Handles MyBook.SheetSelectionChange
MsgBox("TMD!hai bu xing???!!!")
End Sub
试过了,不行。我还试过:
Dim myExcel as New Excel.Application()
Dim WithEvents mySheet as Excel.WorkSheet
....
mySheet=myExcel.ActiveCell.WorkSheet
....
Private Sub mySheet_SelectionChange(ByVal Target as Excel.Range) Handles MySheet.SheetSelectionChange
MsgBox("Niang xi pi!!!")
End Sub
**************************************************************************************************************************************************
MsgBox("TMD!hai bu xing???!!!")
MsgBox("Niang xi pi!!!") |
|