Hi everyone, I'm fairly new at this and I cant seem to find a way around this after searching for answers on google and youtube.
As continuation to my previous thread, I am trying to add comments by referring to the value of a combobox. The target range will follow boundcolumn 2 of Combobox 2.
Combobox 2 range is =R2:S21
I've tried several ways and i'm still stuck so this is one of the entries I've had so far:
ComboBox2.BoundColumn = 2
Dim cb2 As String
cb2 = ComboBox2.Text
Dim cb1 As String
cb1 = ComboBox1.Text
Worksheets("Sheet4").Range("cb2").Select
Worksheets("Sheet4").Range("cb2").AddComment
Worksheets("Sheet4").Range("cb2").Comment.Visible = False
Worksheets("Sheet4").Range("cb2").Comment.Text Text:="cb1" & Chr(10) & "" & Chr(10) & ""
Appreciate any help I can get, Please and thank you
As continuation to my previous thread, I am trying to add comments by referring to the value of a combobox. The target range will follow boundcolumn 2 of Combobox 2.
Combobox 2 range is =R2:S21
I've tried several ways and i'm still stuck so this is one of the entries I've had so far:
VBA Code:
Dim cb2 As String
cb2 = ComboBox2.Text
Dim cb1 As String
cb1 = ComboBox1.Text
Worksheets("Sheet4").Range("cb2").Select
Worksheets("Sheet4").Range("cb2").AddComment
Worksheets("Sheet4").Range("cb2").Comment.Visible = False
Worksheets("Sheet4").Range("cb2").Comment.Text Text:="cb1" & Chr(10) & "" & Chr(10) & ""
VBA Code:
Appreciate any help I can get, Please and thank you