Macro i used to insert commentbox is:
Sub Button25_Click()
'
' Button25_Click Macro
' Macro recorded 11/04/2002 by Radek Ilendo
'
'
Range("I12").Select
Range("I12").AddComment
Range("I12").Comment.Visible = True
Range("I12").Comment.Text Text:="1." & Chr(10) & "2." & Chr(10) & "3." & Chr(10) & ""
Range("I12").Select
ActiveCell.Comment.Visible = False
Range("I13").Select
End Sub
The problem i have is with the second line:
Range("I12").AddComment
as it is always requires debuging and makes macro not working i dunno wot is going wrong.
Could any1 help.
This is one of my latest step to finish my project
luckily.
Sub Button25_Click()
'
' Button25_Click Macro
' Macro recorded 11/04/2002 by Radek Ilendo
'
'
Range("I12").Select
Range("I12").AddComment
Range("I12").Comment.Visible = True
Range("I12").Comment.Text Text:="1." & Chr(10) & "2." & Chr(10) & "3." & Chr(10) & ""
Range("I12").Select
ActiveCell.Comment.Visible = False
Range("I13").Select
End Sub
The problem i have is with the second line:
Range("I12").AddComment
as it is always requires debuging and makes macro not working i dunno wot is going wrong.
Could any1 help.
This is one of my latest step to finish my project
luckily.