VBA: add comments to a cell with target being Combobox2.value and the comment being combobox1.value

[JIB]

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

 

[davesexcel]

Private Sub CommandButton1_Click()

    Dim s As String
    Dim rng As String

    s = Me.ComboBox1
    rng = Me.ComboBox2.Value

    Range(rng).AddComment
    Range(rng).Comment.Visible = False
    Range(rng).Comment.Text Text:=s

End Sub

I set the boundcolumn in the properties for testing purposes.

 

[JIB]

Thank you very much, just what I wanted