Found the Solution... here is the code if anyone finds this userform useful for anything else.
Private Sub txtSuburb_Change()
txtSuburb.Text = UCase(txtSuburb.Text)
End Sub
Private Sub cmdREadd_Click()
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Office")
ActiveDocument.Bookmarks("Office").Select
Selection.TypeText Text:="" & vbCrLf
End With
txtREoffice.SetFocus
End Sub
Private Sub cmdSUBadd_Click()
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Suburb")
ActiveDocument.Bookmarks("Suburb").Select
Selection.TypeText Text:=Trim(txtSuburb.Text) + " * " & vbCrLf
End With
txtSuburb.SetFocus
End Sub
Private Sub cmdLISTadd_Click()
'Application.ScreenUpdating = False
Select Case cboValue.Value
Case "No Value"
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Value")
ActiveDocument.Bookmarks("Value").Select
Selection.TypeText Text:="<->" & Chr(9)
End With
Case "< 400K"
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Value")
ActiveDocument.Bookmarks("Value").Select
Selection.TypeText Text:="" & Chr(9)
End With
Case "400K > < 700K"
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Value")
ActiveDocument.Bookmarks("Value").Select
Selection.TypeText Text:="" & Chr(9)
End With
Case "700K > < 1M"
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Value")
ActiveDocument.Bookmarks("Value").Select
Selection.TypeText Text:="" & Chr(9)
End With
Case "> 1M"
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Value")
ActiveDocument.Bookmarks("Value").Select
Selection.TypeText Text:="" & Chr(9)
End With
End Select
With ActiveDocument.Bookmarks
.Add Range:=Selection.Range, Name:=("Address")
ActiveDocument.Bookmarks("Address").Select
Selection.TypeText Text:=Trim(txtAddress.Value) & Chr(9)
.Add Range:=Selection.Range, Name:=("Date_Time")
ActiveDocument.Bookmarks("Date_Time").Select
Selection.TypeText Text:=Trim(txtDateTime.Value) & Chr(9)
.Add Range:=Selection.Range, Name:=("Agent")
ActiveDocument.Bookmarks("Agent").Select
Selection.TypeText Text:=Trim(txtAgent.Value) & vbCrLf
End With
'Application.ScreenUpdating = False
cboValue.SetFocus
End Sub
Private Sub UserForm_Initialize()
txtREoffice.SetFocus
cboValue.Value = "Select"
With cboValue
.AddItem "No Value"
.AddItem "< 400K"
.AddItem "400K > < 700K"
.AddItem "700K > < 1M"
.AddItem "> 1M"
End With
End Sub
Private Sub cmdClose_Click()
Unload Me ' Close the form
End Sub