How to add comment through VBA

[KFrank]

Hi guys. I have a macro that asks a user to select a cell and then type in a number which is captured to the selected cell. I would like to know how to have the number that is typed to be entered into a comment. This is the code I have so far:

Sub AddCB()
Dim AddHours As String
sCell = Application.InputBox(Prompt:="Select a date", Type:=8)
AddHours = InputBox("How many Call Back hours?", "Add CB Hours", "Enter amount here")
ActiveCell.Value = "CB"
ActiveCell.Offset(0, -1).Value = AddHours
End Sub

I hope someone can help, thank you in advance.

 

[Joe4]

Take a look here: VBA code to insert, delete and control comments - Excel Off The Grid

 

[KFrank]

Thank you for your reply. I have read the attached page yet being new to VBA, I am unsure what to add to my bit of code to use the input data in the comment box.

 

[mikerickson]

Try

ActiveCell.NoteText addHours

Although I do find it odd that the field title ("CB") is the cell's value while the field value is in the comments.
Typically, the value of a field is the cell's contents while the field's title is a column header. Storing values in comments causes problems when one tries to use those values downstream.