-
Hi all, Can anybody tell me how to find out if a cell has a comment attached with it. Using VBA,:- Msgbox activecell.comment.text works ok providing that the cell has a comment. If it hasn't, run-time error 91 is generated. Thanks for any help. John
-
Hi Anonymous! This is how I would add a new worksheet and attach the "Calulate" event handler (the example shows a message box each time the calculate event is triggered): Private Sub NewSheet_Click() Dim oXl As Application: Set oXl = Application oXl.EnableEvents = False oXl.DisplayAlerts ...