I just created some bookmarks for this video, so that I won't need to search the whole video every time. So, either use i or just ignore it: 6:24 Create User Form 7:04 TextBoxes 7:54 Labels 9:03 Buttons 10:30 Code for "Button Clicked" 12:52 Code for Document (just one line: .Show)
Very well done and easy to follow tutorial! Thanks! Question: once I create a document from this template, is there a way to update some of the information (annually, for example), or must I start over with a new template?
@@LearningEngineercom thanks - I actually haven't been able to get the form to open when I create a new document from the template yet, like it does on your video. I'll keep experimenting! Edit: I didn't have the "Private Sub Document_New()" part in my code! :)
This was so easy to follow. Thank you! Two questions - We use sharepoint. Is there a way for all staff to use the same template through Sharepoint or must it be loaded onto every computer? Also, Is there a way to make a button on the ribbon in Word that you can click to launch the template?
This video does as exactly as described, which is awesome if that's what you're looking for. BUT. . . I came here hoping to learn how to apply these concepts to a different project I'm working on. And it was pretty good info up until the point that the code is just copied and pasted. I want to know what all of that code means!!! Otherwise, I can't adapt it and am still looking for how to use this in a way that is helpful for me. It's the old adage "give someone a fish. . ." I really do appreciate the steps up until the code is copied, though.
Any code handy to deal with check boxes in the input form? Here is the goal: If check box is true on input form, check a corresponding check box on the doc and set the values of a variable text box on the input form to a bookmark on the doc? Thanks!
Hi Great video and it does work perfectly. I now have a question, do you know if I can restrict editing on a macro-enable template document? I'm trying to do it and Microsoft word 2016 is not allowing the function. Please I appreciate your response
Hi, thanks for the great content, I'm hoping to create a MS word Forms template which includes IF statements (or any other way) to move the user from one option to the next e.g. If they select London I want them to be presented with options that apply to london like see Tower Bridge, see Big Ben etc. Do you have a video on this type of thing or can you advise if its possible? Thanks
Sorry for the delay. To move from one form to another as though it were a wizard, you only need to .show or hide your forms. You shouldn't need if thens.
How to change font style and size of text output, example when I finish the fill up box and when I click submit, the text output should be bold or underlined
Do you know if it's possible to do this on Mac's Word 2016? I've just opened the VB editor but don't have the same options. I will get Googling, but thought I'd ask anyway...
Hello, I'm trying to make something for my group that will allow other people to use on their computer with a download. I want to create something that I could type into a form and it will go straight to the custom form itself, which I'm sure this tutorial should help. I'm just not sure if I would also be able to make an application/form on the computer that others are able to access that would show instead of me having to use Word as a main source to fill out the information.
Great video! I created a template and saved it as a new Personal template. Although, when the data is filled in the dialog box the hyperlinked items shows number "1" for all entries. Is there a shortcut keys that could be used to open the dialog box for the auto fill texts.
Can you have many text boxes or will i need to creat an additional user form? So say I have 100 questions that require the text boxes, I probably cant fit all of them on one user form. Do I need to creat additional ones? If so how and how will they pop up? Is there an ability to have a next button that will pop up the next dialogue box while in the completed document?
You can have multiple forms or multiple text boxes. If you have multiple forms, you simply use the name of the form to show or hide; for example, form.show form.hide.
Wow thank you so much for this simple but effective video. It's what I needed to know to automate some documents that I deal with everyday. Bravo and much success to you for taking the time and sharing this with others. BTW the links to the code are coming back 404 codes but I copied the code off the screen so no big deal but if you could update the links, it would be a time saver for others.
Thanks for the video, its really helpful. Do you think that you would be able to update the link to the code soon, as its still showing a 404 page fault.
Hi - great video. I too was confused by the code for the "Ok" button around minute 10:30. I am trying to use this video as a guide to create my own fillable form, so I need so more info re: the code. "I have a variable named studentName" - did you create that somehow? Or is it just the label of the first text box without spaces? Sorry if this is a rookie question!
The line Dim studentName as Range is the line that creates the variable studentName. It is not the name of the form, just a variable. The confusion comes from the way in which Word uses the variables and names, which isn't very intuitive.
Thanks for the quick reply. I am trying to create a form to quickly input data into a form letter. I have 9 bookmarks and 9 fields in the form. Do I need to create a variable for all 9 fields? I am getting hung up on how much of your code is relevant to what I am trying to accomplish.
Great video. I have a question. Is there a way to show a text in the textboxes like some kind of example that banishes once you click on them and reapear if you leave them blank?
You can enter or change a page number anytime you want without disturbing the header data. Simply select "insert page number" "current position." this process will put your page number wherever the cursor is and leave the header data as you entered it. I used to think what you said was true...and it's hard to these little secrets.
Hi, great video! At one point you mention that you have to use a unique bookmark for each. I have the same info entered multiple times in a document, is it possible to use the user-form together with the insert>quickparts>field>ref>bookmark function? This can usually be used to link back to a previous instance of a book mark.
Yeah, I haven't had any luck with it either. If I make every bookmark unique, and then link each to the same text box on the form will that work? Basically I have a document where the product name appears multiple times, not just in the header/page title.
I'll probably just end up 'brute forcing' the repeated bookmarks like you've done. However, I have found a few more elegant solutions across the web, however they all seem just beyond my ability. The issue seems to be that when the userform populates the bookmark, it deletes it, and therefore there is no bookmark from which a cross reference can grab data to repeat it? The following link offers a solution, and i've seen it referenced as a good method on other pages as well. I just can't seem to figure out how to get it to work. wordmvp.com/FAQs/MacrosVBA/InsertingTextAtBookmark.htm. The other solution I've come across is www.msofficeforums.com/word-vba/21845-cross-referencing-bookmarks-populated-userform-word-2010-a.html. Such a frustrating process to get something as simple as a bookmark to populate in multiple places throughout a document.
Hi, great tutorial. I'm struggling a bit with the code. I got a bit lost with sending the info to multiple spots on the document. Is this correct: Dim (UserForm caption) As Range Set (UserForm caption)= ActiveDocument.Bookmarks("(bookmark)").Range (UserForm caption).Text = Me.TextBox1.Value
Oh my gosh!! U just solved all my problems! Lol! I needed to create a form for one of my classes and couldn't figure out the last part on bow to save as a template🤔 thanks
I need help creating a drop down tab with filliable information in additional spaces. Say for instance I chose "Boxhead Company" in the drop down tab, I need "Boxhead Companies address, phone number, and fax to automatically fill in,,,,,, is there a way to do this in a Microsoft Word document?
Hey LearningEngineer, thanks for the great video. I am looking desperately for a solution. I want to create a Form in which you can fill out a page and if necessary you can dublicate this exaxt page by clicking on a command button. I am nearly succeeding in creating the right macros, but my problem is that this button won't stay on his place, because above of it I placed a "content control element" which contains for certain choices two written lines and pushes the button down, so he needs to be embedded and stay where he belongs, for gods sake!!! So I really do appreciate an answer from you. Best regards
I must be doing something wrong, I have followed your steps and all seems to be working well as a document, but when I save it as a macros enabled template the document either doesnt populate or my form doesnt show up. Help?!
I have a large project that has been given to me and I think there must be a way to automate it. I have 230 outlines that need to be copied & pasted into a word template. Is there a way to automate the outline into a form and then populate the Word guide template using something similar here? I am not a VBA coder.
So I have a question. I used this option so i could enter information to auto populate into two different forms but i need to know is how can I make the text wrap in the text box of the user form. One of the Text boxes I made is for a narrative and it just continues on where i can't read everything I wrote.
You should be able to make the changes you need to in the "properties" list of the textbook. The two you are probably looking for are "multiline" and "scrollbars." I hope this helps. Let me know if it doesn't.
Thanks! I am looking for something like this for days. Just wanna automate my little law office without paying 100s of Euros for overpriced law software. Can you make a tutorial like this but with checkboxes and dropdown menus? For full range of options when creating a document
Great tutorial. I have created a good handfull of documents for my work based on the tutorial, but I also need to make a textbox, where the user can enter the first page-number (start with pagenumber 34), and then the first page in the document is numbered 34. I know this i possible, but I cannot figure out how. Perhaps something for a new tutorial?
How do I lock the file and just VBA run? When I add a password to the document the VBA doesn't run. Also what if the client want to modify the field after they hit OK?
Is there a way for me to keep track of the names of my bookmarks without me having to exit the vba page and click insert bookmarks and then see what the names of my bookmark? Do I have to keep a record of the names of my bookmarks when I write them down?
I have made the document a couple of times and made it to "enable document" and pops up a "run time error 424" "Object required" and highlights "Debug"
Go into debug and check the name of the thing. For me the issue was that I named my commandbox "form1" instead of what he names his at 6:24 (stInfo). Change the debug line to whatever you named your commandbox and voila it should work.
Can you have radio buttons in a UserForm that can be inserted as a bookmark? I aslo want to put in a reset button that when pushed will bring up the userform to completed again...
Actually, what I'd really like to do is have a UserForm that once Submit button is clicked it will insert the entire UserForm into my Word Document (I've figured out the reset button and Open Form button).
I have one question about the bookmarks, after following the steps i realize that when the bookmarks filled with value it will disappear :(, meaning that document cannot be edited using the userform. Can you help me to figure it out?
@@pardenkracht8x and LearningEngineer.com I am having the same problem with the bookmarks clearing after the submit (works like a charm the first go around though). Did you ever figure out how to keep the bookmarks?
@@LearningEngineercom I don't understand your answer. Is there an additional step to make the form pop up when a new document is created with the template? In the video it just popped up when you opened a new document. I don't see a place in Developer to select the document...? Thanks!
Use this ActiveDocument.ActiveWindow.Close SaveChanges:=wdSaveChanges (to save the document) ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges (not to save the document)
Yes, that's the million-dollar problem. VBA doesn't let you use one variable for all of your bookmarks. No, it doesn't make sense, but it is what it is.
And on that, there is no way to get rid of your brackets? If you turned in a paper with those brackets in place, you would get an F. I've been on this video for 40 minutes and have had to start over ten times because something you have done or haven't done isn't lining up with Word 2016
In MS Word, click on the File menu and then click on the Options button on the left side. In the Options dialogue box click on Advanced. Under Advanced, about half way down under the Show document content heading, uncheck Show bookmarks, and then click the OK button.
If you go to 10:29 in the video, you will see the part where you enter the code. Now, look at the top of the coding page. You will see two drop down menus. The one on the left should be the same as the name of the OK button, and the one on the right should be the trigger event, which in this case is a click.
A good video. What I dont get is why the code is not better organised like this: Dim schoolName As Range Set schoolName = ActiveDocument.Bookmarks("sSchool").Range schoolName.Text = Me.TextBox3.Value Dim studentName As Range Set studentName = ActiveDocument.Bookmarks("sName").Range studentName.Text = Me.TextBox1.Value
Dim paperTitle As Range Set paperTitle = ActiveDocument.Bookmarks("pTitle").Range paperTitle.Text = Me.TextBox2.Value Dim p2Title As Range Set p2Title = ActiveDocument.Bookmarks("p2Title").Range p2Title.Text = Me.TextBox2.Value Dim hTitle As Range Set hTitle = ActiveDocument.Bookmarks("hTitle").Range hTitle.Text = Me.TextBox2.Value Dim h2Title As Range Set h2Title = ActiveDocument.Bookmarks("h2Title").Range h2Title.Text = Me.TextBox2.Value Dim schoolName As Range Set schoolName = ActiveDocument.Bookmarks("sSchool").Range schoolName.Text = Me.TextBox3.Value
hTitle.Font.AllCaps = True h2Title.Font.AllCaps = True Me.Repaint Dim strDocName As String Dim intPos As Integer
You're absolutely correct, I should have done a better job at organizing the code. Your example is clearly better. Thank you for the constructive input.
@@LearningEngineercom I have another query, I created the custom template with bookmarks and a user form. It was working fine but when I attempt to modify the template and add additional bookmarks it wont let me save the changes. Any ideas as to what I'm doing wrong ?
I'm doing this right now and it should be a sin to be stupid because if you make one mistake it wrecks the process. Or you made an error on the part when you get out of the header for the first time. Why can't you justy use the APA style format Word comes with and erase the pages you don't need... it won't let you!!
Good evening, I am having the error 424 Object required when opening the created template. I have added 6 bookmarks to fill. Do you have any advice on what could be the issue? My form is named "Datos". The code is as follows: Private Sub OKButton_Click() Dim Company_name As Range Set name = ActiveDocument.Bookmarks("Company_name").Range name.Text = Me.Campo1.Value Dim address As Range Set address = ActiveDocument.Bookmarks("Company_address").Range address.Text = Me.Campo2.Value Dim town As Range Set town = ActiveDocument.Bookmarks("Company_town").Range town.Text = Me.Campo3.Value Dim zipcode As Range Set zipcode = ActiveDocument.Bookmarks("Company_zipcode").Range zipcode.Text = Me.Campo4.Value Dim Job As Range Set Job = ActiveDocument.Bookmarks("Job_name").Range Job.Text = Me.Campo5.Value Dim ref As Range Set ref = ActiveDocument.Bookmarks("Job_ref").Range ref.Text = Me.Campo6.Value Me.Repaint Datos.Hide End Sub Thanks for any help provided and great tutorial
I just created some bookmarks for this video, so that I won't need to search the whole video every time.
So, either use i or just ignore it:
6:24 Create User Form
7:04 TextBoxes
7:54 Labels
9:03 Buttons
10:30 Code for "Button Clicked"
12:52 Code for Document (just one line: .Show)
Very well done and easy to follow tutorial! Thanks! Question: once I create a document from this template, is there a way to update some of the information (annually, for example), or must I start over with a new template?
You can edit the template. When you open it, don't let the macro run.
@@LearningEngineercom thanks - I actually haven't been able to get the form to open when I create a new document from the template yet, like it does on your video. I'll keep experimenting!
Edit: I didn't have the "Private Sub Document_New()" part in my code! :)
Thanks for the Video! We create hundreds of the exact same form every year and this made it so much quicker
What if we want to create a confirmation letter for different employees year after year in a single word file ?
This was so easy to follow. Thank you! Two questions - We use sharepoint. Is there a way for all staff to use the same template through Sharepoint or must it be loaded onto every computer? Also, Is there a way to make a button on the ribbon in Word that you can click to launch the template?
Marco from Brazil...
Excellent video. It does work perfectly!!!!
Great video. many thanks. Legal Documents are a nuisance in terms of repeating names, etc. This video certainly is a big help
This video does as exactly as described, which is awesome if that's what you're looking for. BUT. . . I came here hoping to learn how to apply these concepts to a different project I'm working on. And it was pretty good info up until the point that the code is just copied and pasted. I want to know what all of that code means!!! Otherwise, I can't adapt it and am still looking for how to use this in a way that is helpful for me. It's the old adage "give someone a fish. . ." I really do appreciate the steps up until the code is copied, though.
I copy the code but then explain what it means.
Hi can you pls reupload the code. It isnot available. Thank you!!
This was SUPER helpful thank you
This was an extremely helpful video. Thank you, sir
Any code handy to deal with check boxes in the input form? Here is the goal: If check box is true on input form, check a corresponding check box on the doc and set the values of a variable text box on the input form to a bookmark on the doc? Thanks!
could you please upload the code again please because it doesn't work anymore and thank you
Hi Great video and it does work perfectly.
I now have a question, do you know if I can restrict editing on a macro-enable template document? I'm trying to do it and Microsoft word 2016 is not allowing the function. Please I appreciate your response
Hi, thanks for the great content, I'm hoping to create a MS word Forms template which includes IF statements (or any other way) to move the user from one option to the next e.g. If they select London I want them to be presented with options that apply to london like see Tower Bridge, see Big Ben etc. Do you have a video on this type of thing or can you advise if its possible? Thanks
Sorry for the delay. To move from one form to another as though it were a wizard, you only need to .show or hide your forms. You shouldn't need if thens.
How to change font style and size of text output, example when I finish the fill up box and when I click submit, the text output should be bold or underlined
Insert the bookmark, then highlight and format the bookmark as though it were a word.
Do you know if it's possible to do this on Mac's Word 2016? I've just opened the VB editor but don't have the same options. I will get Googling, but thought I'd ask anyway...
Sorry, I don't have the answer to that question.
Can you use a current document and use this to add it to certain fields?
Yes, you should be able to do that. You just need a button or keyboard command to trigger the code.
Hello, I'm trying to make something for my group that will allow other people to use on their computer with a download. I want to create something that I could type into a form and it will go straight to the custom form itself, which I'm sure this tutorial should help. I'm just not sure if I would also be able to make an application/form on the computer that others are able to access that would show instead of me having to use Word as a main source to fill out the information.
Great video! I created a template and saved it as a new Personal template. Although, when the data is filled in the dialog box the hyperlinked items shows number "1" for all entries. Is there a shortcut keys that could be used to open the dialog box for the auto fill texts.
Can you have many text boxes or will i need to creat an additional user form? So say I have 100 questions that require the text boxes, I probably cant fit all of them on one user form. Do I need to creat additional ones? If so how and how will they pop up? Is there an ability to have a next button that will pop up the next dialogue box while in the completed document?
You can have multiple forms or multiple text boxes. If you have multiple forms, you simply use the name of the form to show or hide; for example, form.show form.hide.
Hi, the link for VBA code is missing, how can I have it? Thanks for the informative video
You can find it here
www.learningengineer.com/downloads
how thw code would appear to clear the content added?
Wow thank you so much for this simple but effective video. It's what I needed to know to automate some documents that I deal with everyday. Bravo and much success to you for taking the time and sharing this with others. BTW the links to the code are coming back 404 codes but I copied the code off the screen so no big deal but if you could update the links, it would be a time saver for others.
Thanks for the video, its really helpful. Do you think that you would be able to update the link to the code soon, as its still showing a 404 page fault.
The code link is now working. Thanks for letting me know.
Excellent thank you for making this video
Hi - great video. I too was confused by the code for the "Ok" button around minute 10:30. I am trying to use this video as a guide to create my own fillable form, so I need so more info re: the code. "I have a variable named studentName" - did you create that somehow? Or is it just the label of the first text box without spaces? Sorry if this is a rookie question!
The line
Dim studentName as Range
is the line that creates the variable studentName. It is not the name of the form, just a variable.
The confusion comes from the way in which Word uses the variables and names, which isn't very intuitive.
Thanks for the quick reply. I am trying to create a form to quickly input data into a form letter. I have 9 bookmarks and 9 fields in the form. Do I need to create a variable for all 9 fields? I am getting hung up on how much of your code is relevant to what I am trying to accomplish.
Yes, each one will need its own variable.
@@LearningEngineercom I did this before but trying to duplicate it and i'm lost at the dim studentname as a range, how do you create the variable?
Great video. I have a question. Is there a way to show a text in the textboxes like some kind of example that banishes once you click on them and reapear if you leave them blank?
I will be creating a video in response to your request.
Here is a link to the new video. th-cam.com/video/yNDbUL5V8HE/w-d-xo.html
Thank you! Much appreciated.
You can enter or change a page number anytime you want without disturbing the header data. Simply select "insert page number" "current position." this process will put your page number wherever the cursor is and leave the header data as you entered it. I used to think what you said was true...and it's hard to these little secrets.
Is it possible to have different formatting/font for hTitle and h2Title?
Hi, great video! At one point you mention that you have to use a unique bookmark for each. I have the same info entered multiple times in a document, is it possible to use the user-form together with the insert>quickparts>field>ref>bookmark function? This can usually be used to link back to a previous instance of a book mark.
You can certainly try that. I believe that used to work. However, I tried several different methods to shortcut the process and none of them worked.
Yeah, I haven't had any luck with it either. If I make every bookmark unique, and then link each to the same text box on the form will that work? Basically I have a document where the product name appears multiple times, not just in the header/page title.
Yes, each bookmark has to be unique.
I'll probably just end up 'brute forcing' the repeated bookmarks like you've done. However, I have found a few more elegant solutions across the web, however they all seem just beyond my ability.
The issue seems to be that when the userform populates the bookmark, it deletes it, and therefore there is no bookmark from which a cross reference can grab data to repeat it? The following link offers a solution, and i've seen it referenced as a good method on other pages as well. I just can't seem to figure out how to get it to work.
wordmvp.com/FAQs/MacrosVBA/InsertingTextAtBookmark.htm.
The other solution I've come across is www.msofficeforums.com/word-vba/21845-cross-referencing-bookmarks-populated-userform-word-2010-a.html.
Such a frustrating process to get something as simple as a bookmark to populate in multiple places throughout a document.
Hi, great tutorial. I'm struggling a bit with the code. I got a bit lost with sending the info to multiple spots on the document.
Is this correct:
Dim (UserForm caption) As Range
Set (UserForm caption)= ActiveDocument.Bookmarks("(bookmark)").Range
(UserForm caption).Text = Me.TextBox1.Value
All Good, I worked it out :)
Hi, i am also struggling with this. Is (Userform caption) the caption you gived to TextBox ?
Oh my gosh!! U just solved all my problems! Lol! I needed to create a form for one of my classes and couldn't figure out the last part on bow to save as a template🤔 thanks
I need help creating a drop down tab with filliable information in additional spaces. Say for instance I chose "Boxhead Company" in the drop down tab, I need "Boxhead Companies address, phone number, and fax to automatically fill in,,,,,, is there a way to do this in a Microsoft Word document?
Hey LearningEngineer, thanks for the great video. I am looking desperately for a solution. I want to create a Form in which you can fill out a page and if necessary you can dublicate this exaxt page by clicking on a command button. I am nearly succeeding in creating the right macros, but my problem is that this button won't stay on his place, because above of it I placed a
"content control element" which contains for certain choices two written lines and pushes the button down, so he needs to be embedded and stay where he belongs, for gods sake!!! So I really do appreciate an answer from you. Best regards
Is your button on a form or in the document itself?
I must be doing something wrong, I have followed your steps and all seems to be working well as a document, but when I save it as a macros enabled template the document either doesnt populate or my form doesnt show up. Help?!
That usually means that you haven't set it in the open_document or new_document event.
I have a large project that has been given to me and I think there must be a way to automate it. I have 230 outlines that need to be copied & pasted into a word template. Is there a way to automate the outline into a form and then populate the Word guide template using something similar here? I am not a VBA coder.
I not quite sure what you're trying to do.
Hello, how I can make this method when I save the document and not when I open?
So I have a question. I used this option so i could enter information to auto populate into two different forms but i need to know is how can I make the text wrap in the text box of the user form. One of the Text boxes I made is for a narrative and it just continues on where i can't read everything I wrote.
You should be able to make the changes you need to in the "properties" list of the textbook. The two you are probably looking for are "multiline" and "scrollbars." I hope this helps. Let me know if it doesn't.
Yes. Thank you. Changing multiline to true fixed the issue. Thanks
Thanks! I am looking for something like this for days. Just wanna automate my little law office without paying 100s of Euros for overpriced law software.
Can you make a tutorial like this but with checkboxes and dropdown menus? For full range of options when creating a document
Yes, I can do that.
LearningEngineer.com Wow thanks a lot! I subscribed.
Hi there. Is there a way to access the created dialogue box while in the document? Thanks.
Yes, but you would need to attach the macro to a key combination or some other type of event.
nvm.. I just tried new window open instead of new and that did the trick! thanks
Hey Mirsa, I'm having the same issue. How did you fix it because I don't know what you mean by new window open instead of new?
Great tutorial. I have created a good handfull of documents for my work based on the tutorial, but I also need to make a textbox, where the user can enter the first page-number (start with pagenumber 34), and then the first page in the document is numbered 34. I know this i possible, but I cannot figure out how. Perhaps something for a new tutorial?
I am looking for someone to help me create a form. Do you do that for as well? Thanks..
Great video!
Just a request: could you update the new file and code links? These are giving a 404 page right now.
I fixed the file link but still working on the code link.
Excellent tutorial. I have a question: I want to create a user form with a list of names/addresses to auto fill the document... any recommendations?
When you create your form, instead of using a textbox, use a drop down list. You can fill the drop down list with whatever you want.
How do I lock the file and just VBA run? When I add a password to the document the VBA doesn't run. Also what if the client want to modify the field after they hit OK?
That's a security issue. You have to make the document a trusted document in your MS Office environment.
Is there a way for me to keep track of the names of my bookmarks without me having to exit the vba page and click insert bookmarks and then see what the names of my bookmark? Do I have to keep a record of the names of my bookmarks when I write them down?
I did some research and could not find an easy way to reference them.
Wow thanks for the quick reply! Do you then just make sure the names you give are intuitive so you remember them later?
I have made the document a couple of times and made it to "enable document" and pops up a "run time error 424" "Object required" and highlights "Debug"
Go into debug and check the name of the thing. For me the issue was that I named my commandbox "form1" instead of what he names his at 6:24 (stInfo). Change the debug line to whatever you named your commandbox and voila it should work.
Great video! Congratulations.
Hey! I've done this a few times and copied and pasted your code. When I open the new template, I get a "run time error 424" code.
A 424 code means that one of your form objects or bookmarks doesn't have the same name as in the code.
Excellent video. Its easy to work with excel docs, but MS didn't make it as easy work with the word docs.
Link is broken, do you have the code or file elsewhere?
learningengineer.com/cloud/code.txt
I can't add a user form when I open Visual Basic . what should I do ?
Can you have radio buttons in a UserForm that can be inserted as a bookmark? I aslo want to put in a reset button that when pushed will bring up the userform to completed again...
Actually, what I'd really like to do is have a UserForm that once Submit button is clicked it will insert the entire UserForm into my Word Document (I've figured out the reset button and Open Form button).
Lisa Mykytik
I have one question about the bookmarks, after following the steps i realize that when the bookmarks filled with value it will disappear :(, meaning that document cannot be edited using the userform. Can you help me to figure it out?
I need to create a macro that opens the stInfo form; however, you also need to clear out the bookmarks. I am looking into this now.
Looking forward for your next update 😊
@@pardenkracht8x and LearningEngineer.com I am having the same problem with the bookmarks clearing after the submit (works like a charm the first go around though). Did you ever figure out how to keep the bookmarks?
@@jk501111 yes I do, but I'm storing my data using Ms. Excel and then use mail merge in Ms Word to call the datas to the template that I made.
How to make a field mandatory in the form?
I believe it is in the list of properties.
I got lost in minute 10:24 when fix the button Ok. About the information copied from the yellow icon. Where can I get it and where do I originate it?
Sorry, that was the wrong link.
practiceengineer.com/nextcloud/index.php/s/08LpS7hYBUvfxPV
Hello, this link no longer works anymore? is there still a way i can get the information?
Is this Works on Mac os?
@@LearningEngineercom thank u
Where is the link to the code for the cancel button please?
OK button*
www.learningengineer.org/home/downloads/apaformcode.txt?attredirects=0&d=1
Hi. I just made this form... and I believe I followed all your steps, but the form does not pop up upon open.
That's because you have to tell it to open when the document opens. In developer you have to select the document to open those commands.
@@LearningEngineercom I don't understand your answer. Is there an additional step to make the form pop up when a new document is created with the template? In the video it just popped up when you opened a new document. I don't see a place in Developer to select the document...? Thanks!
Where is the code?
You can find the document here learningengineer.com/cloud/docs/Automated%20APA%20Form%20Document.docm
When the user hits "Cancel", how could you also have it close the new document in addition to hiding the dialogue box?
Use this ActiveDocument.ActiveWindow.Close SaveChanges:=wdSaveChanges (to save the document)
ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges (not to save the document)
Thank u bro
I Have To Many Name Of Same Person In My Document on different pages. How to Fill Name To Many Places using Only one Bookmark i.e "Name"
Yes, that's the million-dollar problem. VBA doesn't let you use one variable for all of your bookmarks. No, it doesn't make sense, but it is what it is.
Maybe I am missing something but what kind of object is "Me"?
It's the same as "this" in javascript I would say.
You didn't tell us how to create or identify the 'variables'?? Can't finish my doc
Dim Variable as Range.
And on that, there is no way to get rid of your brackets? If you turned in a paper with those brackets in place, you would get an F. I've been on this video for 40 minutes and have had to start over ten times because something you have done or haven't done isn't lining up with Word 2016
In MS Word, click on the File menu and then click on the Options button on the left side. In the Options dialogue box click on Advanced. Under Advanced, about half way down under the Show document content heading, uncheck Show bookmarks, and then click the OK button.
THANK YOU!!!
My okay button wont click, hence the form wont fill
If you go to 10:29 in the video, you will see the part where you enter the code. Now, look at the top of the coding page. You will see two drop down menus. The one on the left should be the same as the name of the OK button, and the one on the right should be the trigger event, which in this case is a click.
Thank you
if you wouldn't mind- can I contact you via email or something ? I had some questions.
A good video. What I dont get is why the code is not better organised like this:
Dim schoolName As Range
Set schoolName = ActiveDocument.Bookmarks("sSchool").Range
schoolName.Text = Me.TextBox3.Value
Dim studentName As Range
Set studentName = ActiveDocument.Bookmarks("sName").Range
studentName.Text = Me.TextBox1.Value
Dim paperTitle As Range
Set paperTitle = ActiveDocument.Bookmarks("pTitle").Range
paperTitle.Text = Me.TextBox2.Value
Dim p2Title As Range
Set p2Title = ActiveDocument.Bookmarks("p2Title").Range
p2Title.Text = Me.TextBox2.Value
Dim hTitle As Range
Set hTitle = ActiveDocument.Bookmarks("hTitle").Range
hTitle.Text = Me.TextBox2.Value
Dim h2Title As Range
Set h2Title = ActiveDocument.Bookmarks("h2Title").Range
h2Title.Text = Me.TextBox2.Value
Dim schoolName As Range
Set schoolName = ActiveDocument.Bookmarks("sSchool").Range
schoolName.Text = Me.TextBox3.Value
hTitle.Font.AllCaps = True
h2Title.Font.AllCaps = True
Me.Repaint
Dim strDocName As String
Dim intPos As Integer
You're absolutely correct, I should have done a better job at organizing the code. Your example is clearly better. Thank you for the constructive input.
Great video, when I type stinfo, i dont get the popup to allow me to add the hide command. What am I doing wrong ?
It's case sensitive, so the name in the video stInfo has a capital "I" in the name. So, that may be why.
@@LearningEngineercom thanks, figured it out. I had a label name incorrect.
@@LearningEngineercom I have another query, I created the custom template with bookmarks and a user form. It was working fine but when I attempt to modify the template and add additional bookmarks it wont let me save the changes. Any ideas as to what I'm doing wrong ?
I'm doing this right now and it should be a sin to be stupid because if you make one mistake it wrecks the process. Or you made an error on the part when you get out of the header for the first time. Why can't you justy use the APA style format Word comes with and erase the pages you don't need... it won't let you!!
If you go to www dot learningengineer dot org forward slash downloads
it is the fifth file down: Apa.docm.
Good evening,
I am having the error 424 Object required when opening the created template. I have added 6 bookmarks to fill. Do you have any advice on what could be the issue?
My form is named "Datos". The code is as follows:
Private Sub OKButton_Click()
Dim Company_name As Range
Set name = ActiveDocument.Bookmarks("Company_name").Range
name.Text = Me.Campo1.Value
Dim address As Range
Set address = ActiveDocument.Bookmarks("Company_address").Range
address.Text = Me.Campo2.Value
Dim town As Range
Set town = ActiveDocument.Bookmarks("Company_town").Range
town.Text = Me.Campo3.Value
Dim zipcode As Range
Set zipcode = ActiveDocument.Bookmarks("Company_zipcode").Range
zipcode.Text = Me.Campo4.Value
Dim Job As Range
Set Job = ActiveDocument.Bookmarks("Job_name").Range
Job.Text = Me.Campo5.Value
Dim ref As Range
Set ref = ActiveDocument.Bookmarks("Job_ref").Range
ref.Text = Me.Campo6.Value
Me.Repaint
Datos.Hide
End Sub
Thanks for any help provided and great tutorial
Can you send me a copy of your document at mikes4bikes@gmail.com