Hello...
I am trying to create a form that people fill in and then the data is transferred into a new document created from a template. The Form now opens when the template is open (thank you XL Guru) but I cannot seem to get the data to transfer...
I have created a 'textform field option' in a cell in word which I have called 'Price' in the 'Bookmark:' section.
I have then entered the following code into the userform module (my user form is called userform1):
Private Sub btnUserOK_Click()
End Sub
Private Sub TextBoxPrice_Change()
vprice = UserForm1.TextBoxPrice.Text
ActiveDocument.FormFields("bkprice").Result = vprice
End Sub
I am quite new to all this so you will have to excuse my ignorance if this is complete garbage...
Do I have to enter the code into the 'Userform1 module' or the 'thisdocument' module.
I then have an OK button which I want to click and the data then be entered into the appropriate 'textform field option'
Any help will be greatly appreciated..
Thank you
I am trying to create a form that people fill in and then the data is transferred into a new document created from a template. The Form now opens when the template is open (thank you XL Guru) but I cannot seem to get the data to transfer...
I have created a 'textform field option' in a cell in word which I have called 'Price' in the 'Bookmark:' section.
I have then entered the following code into the userform module (my user form is called userform1):
Private Sub btnUserOK_Click()
End Sub
Private Sub TextBoxPrice_Change()
vprice = UserForm1.TextBoxPrice.Text
ActiveDocument.FormFields("bkprice").Result = vprice
End Sub
I am quite new to all this so you will have to excuse my ignorance if this is complete garbage...
Do I have to enter the code into the 'Userform1 module' or the 'thisdocument' module.
I then have an OK button which I want to click and the data then be entered into the appropriate 'textform field option'
Any help will be greatly appreciated..
Thank you