Creating a Word 2016 document that automatically fills with form data. (APA style)

  Рет қаралды 343,270

LearningEngineer.com

LearningEngineer.com

7 жыл бұрын

In this video, I demonstrate how to create a form in MS Word 2016 that automatically fills in the document's bookmarks. The document is an APA formatted document.
Create User Form 6:24
TextBoxes 7:04
Labels 7:54
Buttons 9:03
Code for Button's click 10:30
Code for Document 12:52
Click here to download the new file:
learningengineer.com/cloud/do...
Click here for the code
www.learningengineer.com/down...

Пікірлер: 145
@coryhaberberger9437
@coryhaberberger9437 4 жыл бұрын
Thanks for the Video! We create hundreds of the exact same form every year and this made it so much quicker
@kingcobralive3081
@kingcobralive3081 3 ай бұрын
What if we want to create a confirmation letter for different employees year after year in a single word file ?
@alfsilva
@alfsilva 4 жыл бұрын
Great video. many thanks. Legal Documents are a nuisance in terms of repeating names, etc. This video certainly is a big help
@arquivoxjk
@arquivoxjk 3 жыл бұрын
Marco from Brazil... Excellent video. It does work perfectly!!!!
@machinimaaquinix3178
@machinimaaquinix3178 6 жыл бұрын
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.
@alexmcmahon1808
@alexmcmahon1808 2 жыл бұрын
This was SUPER helpful thank you
@pabloescobanjo4553
@pabloescobanjo4553 6 жыл бұрын
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)
@Sportybros2244
@Sportybros2244 2 жыл бұрын
This was an extremely helpful video. Thank you, sir
@missolena
@missolena 6 жыл бұрын
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
@andersondallmann
@andersondallmann 6 жыл бұрын
Great video! Congratulations.
@chrstnptt3398
@chrstnptt3398 4 жыл бұрын
Excellent thank you for making this video
@Whileworking
@Whileworking 7 жыл бұрын
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.
@EpicBizHero
@EpicBizHero 6 жыл бұрын
THANK YOU!!!
@katpesino207
@katpesino207 5 жыл бұрын
Hi can you pls reupload the code. It isnot available. Thank you!!
@kristofferfalk5339
@kristofferfalk5339 6 жыл бұрын
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?
@irazucc
@irazucc 6 жыл бұрын
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
@jewelliel6159
@jewelliel6159 6 жыл бұрын
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?
@Keburin
@Keburin 5 жыл бұрын
Is it possible to have different formatting/font for hTitle and h2Title?
@ralfpires56
@ralfpires56 5 жыл бұрын
Hello, how I can make this method when I save the document and not when I open?
@CryptEclipse
@CryptEclipse 4 жыл бұрын
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.
@mirsasanxhaku4076
@mirsasanxhaku4076 7 жыл бұрын
nvm.. I just tried new window open instead of new and that did the trick! thanks
@Imnotmaxed
@Imnotmaxed 7 жыл бұрын
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?
@katybertoldi5817
@katybertoldi5817 4 жыл бұрын
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!
@marlongarcia4705
@marlongarcia4705 6 жыл бұрын
Thank you
@fedaalayoun4719
@fedaalayoun4719 5 жыл бұрын
I can't add a user form when I open Visual Basic . what should I do ?
@ReneeWood-ov5uk
@ReneeWood-ov5uk Жыл бұрын
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?
@primemychakras818
@primemychakras818 5 жыл бұрын
I am looking for someone to help me create a form. Do you do that for as well? Thanks..
@ataata8118
@ataata8118 4 жыл бұрын
Thank u bro
@sanityone649
@sanityone649 6 жыл бұрын
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.
@essamhashem9618
@essamhashem9618 5 жыл бұрын
could you please upload the code again please because it doesn't work anymore and thank you
@itsmeforsure5475
@itsmeforsure5475 5 жыл бұрын
Excellent video. Its easy to work with excel docs, but MS didn't make it as easy work with the word docs.
@mrboss2023
@mrboss2023 6 жыл бұрын
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?
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
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.
@GRumpyonekinobi
@GRumpyonekinobi 2 жыл бұрын
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
@LearningEngineercom
@LearningEngineercom Жыл бұрын
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.
@hanslauroschnittger6709
@hanslauroschnittger6709 4 жыл бұрын
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
@LearningEngineercom
@LearningEngineercom 4 жыл бұрын
Is your button on a form or in the document itself?
@TwizzlyStick
@TwizzlyStick 7 жыл бұрын
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...
@LearningEngineercom
@LearningEngineercom 7 жыл бұрын
Sorry, I don't have the answer to that question.
@s3rmak123
@s3rmak123 6 жыл бұрын
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?
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
I will be creating a video in response to your request.
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
Here is a link to the new video. kzfaq.info/get/bejne/r7R0lbh9mryceHk.html
@s3rmak123
@s3rmak123 6 жыл бұрын
Thank you! Much appreciated.
@angelapace3773
@angelapace3773 Жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom Жыл бұрын
I copy the code but then explain what it means.
@marremus
@marremus 4 жыл бұрын
how thw code would appear to clear the content added?
@kimschamp9642
@kimschamp9642 6 жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
I not quite sure what you're trying to do.
@marlongarcia4705
@marlongarcia4705 6 жыл бұрын
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?
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
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.
@lauraanderson3037
@lauraanderson3037 7 жыл бұрын
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
@lauraanderson3037
@lauraanderson3037 7 жыл бұрын
All Good, I worked it out :)
@RichardSchmitz12
@RichardSchmitz12 3 жыл бұрын
Hi, i am also struggling with this. Is (Userform caption) the caption you gived to TextBox ?
@erikasulcaite1095
@erikasulcaite1095 7 жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom 7 жыл бұрын
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.
@erikasulcaite1095
@erikasulcaite1095 7 жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom 7 жыл бұрын
Yes, each bookmark has to be unique.
@senorsuave
@senorsuave 6 жыл бұрын
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.
@KarenS-tm9sv
@KarenS-tm9sv 3 ай бұрын
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
@LearningEngineercom 3 ай бұрын
You can edit the template. When you open it, don't let the macro run.
@KarenS-tm9sv
@KarenS-tm9sv 3 ай бұрын
@@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! :)
@dwaynemurphy8229
@dwaynemurphy8229 6 жыл бұрын
Hi there. Is there a way to access the created dialogue box while in the document? Thanks.
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
Yes, but you would need to attach the macro to a key combination or some other type of event.
@ervingay5095
@ervingay5095 6 жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
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.
@ervingay5095
@ervingay5095 6 жыл бұрын
Yes. Thank you. Changing multiline to true fixed the issue. Thanks
@buttondp
@buttondp 6 жыл бұрын
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"
@singularitie6401
@singularitie6401 5 жыл бұрын
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.
@larathreet7391
@larathreet7391 6 жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
A 424 code means that one of your form objects or bookmarks doesn't have the same name as in the code.
@brittneydelossantos8723
@brittneydelossantos8723 3 жыл бұрын
Can you use a current document and use this to add it to certain fields?
@LearningEngineercom
@LearningEngineercom 3 жыл бұрын
Yes, you should be able to do that. You just need a button or keyboard command to trigger the code.
@MrWombatsiide
@MrWombatsiide 5 жыл бұрын
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?!
@LearningEngineercom
@LearningEngineercom 5 жыл бұрын
That usually means that you haven't set it in the open_document or new_document event.
@chadhansen6650
@chadhansen6650 6 жыл бұрын
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!
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
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.
@chadhansen6650
@chadhansen6650 6 жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
Yes, each one will need its own variable.
@coldheater1
@coldheater1 4 жыл бұрын
@@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?
@LamBoyzzz
@LamBoyzzz 2 жыл бұрын
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
@LearningEngineercom
@LearningEngineercom Жыл бұрын
Insert the bookmark, then highlight and format the bookmark as though it were a word.
@HA-no3jh
@HA-no3jh 4 жыл бұрын
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
@LearningEngineercom
@LearningEngineercom 4 жыл бұрын
Yes, I can do that.
@HA-no3jh
@HA-no3jh 4 жыл бұрын
LearningEngineer.com Wow thanks a lot! I subscribed.
@lisamykytik4902
@lisamykytik4902 7 жыл бұрын
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...
@lisamykytik4902
@lisamykytik4902 7 жыл бұрын
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).
@breezyj226
@breezyj226 7 жыл бұрын
Lisa Mykytik
@MrHugocad
@MrHugocad 6 жыл бұрын
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?
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
Sorry, that was the wrong link. practiceengineer.com/nextcloud/index.php/s/08LpS7hYBUvfxPV
@celestemartinez5545
@celestemartinez5545 6 жыл бұрын
Hello, this link no longer works anymore? is there still a way i can get the information?
@AdvancedSimTech
@AdvancedSimTech 2 жыл бұрын
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.
@LearningEngineercom
@LearningEngineercom 2 жыл бұрын
The code link is now working. Thanks for letting me know.
@joeyhensley18
@joeyhensley18 4 жыл бұрын
When the user hits "Cancel", how could you also have it close the new document in addition to hiding the dialogue box?
@nd8961
@nd8961 4 жыл бұрын
Use this ActiveDocument.ActiveWindow.Close SaveChanges:=wdSaveChanges (to save the document) ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges (not to save the document)
@dabketroop
@dabketroop 3 жыл бұрын
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?
@LearningEngineercom
@LearningEngineercom Жыл бұрын
That's a security issue. You have to make the document a trusted document in your MS Office environment.
@waliurrahman4295
@waliurrahman4295 5 жыл бұрын
if you wouldn't mind- can I contact you via email or something ? I had some questions.
@pardenkracht8x
@pardenkracht8x 5 жыл бұрын
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?
@LearningEngineercom
@LearningEngineercom 5 жыл бұрын
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.
@pardenkracht8x
@pardenkracht8x 5 жыл бұрын
Looking forward for your next update 😊
@jk501111
@jk501111 4 жыл бұрын
@@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?
@pardenkracht8x
@pardenkracht8x 4 жыл бұрын
@@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.
@adityaitalia648
@adityaitalia648 4 жыл бұрын
How to make a field mandatory in the form?
@LearningEngineercom
@LearningEngineercom Жыл бұрын
I believe it is in the list of properties.
@mirsasanxhaku4076
@mirsasanxhaku4076 7 жыл бұрын
Hi. I just made this form... and I believe I followed all your steps, but the form does not pop up upon open.
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
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.
@KarenS-tm9sv
@KarenS-tm9sv 3 ай бұрын
@@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!
@crispy2102
@crispy2102 7 жыл бұрын
Maybe I am missing something but what kind of object is "Me"?
@LearningEngineercom
@LearningEngineercom 6 жыл бұрын
It's the same as "this" in javascript I would say.
@henrymason7910
@henrymason7910 3 жыл бұрын
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?
@LearningEngineercom
@LearningEngineercom 3 жыл бұрын
I did some research and could not find an easy way to reference them.
@henrymason7910
@henrymason7910 3 жыл бұрын
Wow thanks for the quick reply! Do you then just make sure the names you give are intuitive so you remember them later?
@gholamrezav.ebrahimi6051
@gholamrezav.ebrahimi6051 Жыл бұрын
Hi, the link for VBA code is missing, how can I have it? Thanks for the informative video
@LearningEngineercom
@LearningEngineercom Жыл бұрын
You can find it here www.learningengineer.com/downloads
@shawnkelley2248
@shawnkelley2248 7 жыл бұрын
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
@LearningEngineercom
@LearningEngineercom 7 жыл бұрын
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.
@BartvandeGriendt
@BartvandeGriendt 2 жыл бұрын
Great video! Just a request: could you update the new file and code links? These are giving a 404 page right now.
@LearningEngineercom
@LearningEngineercom 2 жыл бұрын
I fixed the file link but still working on the code link.
@TruthShallPrevail4
@TruthShallPrevail4 4 жыл бұрын
Link is broken, do you have the code or file elsewhere?
@LearningEngineercom
@LearningEngineercom 4 жыл бұрын
learningengineer.com/cloud/code.txt
@oliveredwards566
@oliveredwards566 5 жыл бұрын
Where is the link to the code for the cancel button please?
@oliveredwards566
@oliveredwards566 5 жыл бұрын
OK button*
@LearningEngineercom
@LearningEngineercom 5 жыл бұрын
www.learningengineer.org/home/downloads/apaformcode.txt?attredirects=0&d=1
@renesaccardo
@renesaccardo 4 жыл бұрын
Is this Works on Mac os?
@renesaccardo
@renesaccardo 4 жыл бұрын
@@LearningEngineercom thank u
@Imnotmaxed
@Imnotmaxed 7 жыл бұрын
My okay button wont click, hence the form wont fill
@LearningEngineercom
@LearningEngineercom 7 жыл бұрын
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.
@truthmadesolidarts5581
@truthmadesolidarts5581 4 жыл бұрын
Where is the code?
@LearningEngineercom
@LearningEngineercom 4 жыл бұрын
You can find the document here learningengineer.com/cloud/docs/Automated%20APA%20Form%20Document.docm
@anooop.143
@anooop.143 3 жыл бұрын
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"
@LearningEngineercom
@LearningEngineercom 3 жыл бұрын
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.
@Hishersmein
@Hishersmein 3 жыл бұрын
You didn't tell us how to create or identify the 'variables'?? Can't finish my doc
@LearningEngineercom
@LearningEngineercom Жыл бұрын
Dim Variable as Range.
@shawnkelley2248
@shawnkelley2248 7 жыл бұрын
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!!
@LearningEngineercom
@LearningEngineercom 7 жыл бұрын
If you go to www dot learningengineer dot org forward slash downloads it is the fifth file down: Apa.docm.
@johnmccready9573
@johnmccready9573 3 жыл бұрын
Great video, when I type stinfo, i dont get the popup to allow me to add the hide command. What am I doing wrong ?
@LearningEngineercom
@LearningEngineercom 3 жыл бұрын
It's case sensitive, so the name in the video stInfo has a capital "I" in the name. So, that may be why.
@johnmccready9573
@johnmccready9573 3 жыл бұрын
@@LearningEngineercom thanks, figured it out. I had a label name incorrect.
@johnmccready9573
@johnmccready9573 3 жыл бұрын
@@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 ?
@grantgray1201
@grantgray1201 3 жыл бұрын
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
@LearningEngineercom
@LearningEngineercom 3 жыл бұрын
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.
@manuelsolerbarreda1662
@manuelsolerbarreda1662 2 жыл бұрын
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
@LearningEngineercom
@LearningEngineercom 2 жыл бұрын
Can you send me a copy of your document at mikes4bikes@gmail.com
Customized Building Block (Quick Parts Menu) in Your MS Word 2013 Document
5:32
Pt 3: Using a form, bookmarks, and VBA in MS Word to fill a document.
46:02
LearningEngineer.com
Рет қаралды 16 М.
Best KFC Homemade For My Son #cooking #shorts
00:58
BANKII
Рет қаралды 73 МЛН
Amazing weight loss transformation !! 😱😱
00:24
Tibo InShape
Рет қаралды 67 МЛН
World’s Largest Jello Pool
01:00
Mark Rober
Рет қаралды 110 МЛН
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 25 МЛН
How to make Fillable Form in Microsoft Word
12:00
Kevin Stratvert
Рет қаралды 1,6 МЛН
Creating IF Statements in Microsoft Word templates
5:21
Conga
Рет қаралды 173 М.
Creating Interactive Forms in MS Word
13:20
Excel Insights
Рет қаралды 6 М.
How To Export Word Form Data Fields To Excel
7:18
Sharon Smith
Рет қаралды 116 М.
This video explains how to use bookmarks and fields in Microsoft Word
8:04
Creating a basic MS Word Form
14:52
LearningEngineer.com
Рет қаралды 286
Auto-populate a word document with excel data
4:23
LTalpacas
Рет қаралды 168 М.
Best KFC Homemade For My Son #cooking #shorts
00:58
BANKII
Рет қаралды 73 МЛН