Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok, I searched the boards and found thomas cool's solution to making an
event fire from any sheet or worksheet without using class modules. I have the following code in ThisWorkbook of my add-in Private Sub xlsMonitor_SheetChange(ByVal Sh As Object, ByVal Target As Range) On Error Resume Next Application.EnableEvents = False If ActiveCell.Comment.text < "" Then Application.StatusBar = ActiveCell.Comment.text Else Application.StatusBar = False End If Application.EnableEvents = True End Sub All I am trying to do is set it up so that any time I am in a cell with a comment, the comment is displayed in the status bar. I was able to get similar code to work when I put the code in ThisWorkbook of an actual workbook using Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Why will this not work? Any help is greatly appreciated. Will |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation list changes don't fire an event | Excel Programming | |||
Event doesn't fire | Excel Discussion (Misc queries) | |||
Fire Event only when Cell Change? | Excel Programming | |||
Workbook Open event does not fire | Excel Programming | |||
Event class doesn't fire in embedded VBA | Excel Programming |