How can I make my code add text the the front or left of a textbox on a userform?

[vbaNumpty]

I have a checkbox on a userform and I would like for it to add text to a text box, without replacing the contents if there already is something in the textbox.

I would like for it to be added to the left most of the textbox, essentially being the first text that is viewed when reading the contents.

I have used an if to make the textbox1.text= abc, but I don't want to replace all the contents when there are already some notes in the textbox.

For example if the textbox had the following in it Customer Wants Blue Pots

The end result would be : abc - Customer Wants Blue Pots

 

[vbaNumpty]

I have tried the following but I get an object error:

Private Sub NeedReview_Change()

    Dim existingNotes As String
    
    Set existingNotes = NotesBox.Value

    If NeedReview.Value = True Then NotesBox.Text = "NEEDS REVIEW - " & existingNotes
    
    

End Sub

 

[vbaNumpty]

Turns out I had to remove the Set