Hi, I'm new to this forum, I've never used VBA programming before so I'm hoping someone might be able to help me ...

I'm trying to create a form in excel where I press a button at the end of completing my form and it populates a word template with bookmarks outlining where specific fields on my form should be inserted.

I have started with the below script but I've only ever done a very basic course and I'm trying to teach myself, my trainer told me this was advanced so I'm looking for a bit of help as my company won't send me on an intermediate and advanced course yet because I dont' really need it other than to do this so they feel it's a waste of money! this is basically the only reason I need it!

I've done the below, which is at the moment opening my draft word doc but not populating it. At the point where I ask it to select the bookmark I'm not sure what I need to put next, I want to say take the text in textbox1 and put it in the 'reference' bookmark in the word template but I don't know how to tell it to select it and insert it? any help would be really appreciated! Thanks so much!!!

Having the same problem with the radio buttons - asking to select the optionbutton and wanting to it to populate the template bookmark I reference in the script.

hope this makes sense to someone....


Private Sub CommandButton1_Click()
Dim wapp As Word.Application
Dim wdoc As Word.Document
Set wapp = CreateObject("Word.Application")
Set wdoc = wapp.Documents.Open("J:\SoDaN Test\SoDaN Test Template.dotx")
wapp.Visible = True

wapp.Selection.Goto what:=wdGoToBookmark, Name:="Reference"

If Me.OptionButton1 = True Then
wapp.Selection.Goto what:=wdGoToBookmark, Name:="AddOns"
wdoc.Selection.TypeText.Sheet2 Range("b2")
ElseIf Me.OptionButton2 = True Then
Selection.TypeText.Sheet2 Range("b3")
End If