This is literally so helpful! 3 years on and you're still saving our asses - I need to automate a form in Word at my job and I would be so lost if you hadn't made this tutorial thank you so much
@kurtjacobson46723 күн бұрын
You're not the only one, and it took you so long because it's not very intuitive that the option even exists. Thanks for creating this video. It's been a great reminder. For years I was separating each textual element to create timed animations on them until a client asked me to update an old course and I had to search YT to find out how they had textual elements in the same box animating separately.
@aaroneakins8258Ай бұрын
How would I do this using text box? I need to have a text box send to two or more bookmarks.
@LearningEngineercomАй бұрын
I have several videos that provide instructions on how to do just that. Go to my channel.
@michaelgergen4318Ай бұрын
Someone has beef with Poland lol
@LearningEngineercomАй бұрын
Someone is using a strawman argument. Not Poland. Just this bad faith argument.
@georgepiet496Ай бұрын
No this is not Poland. A country is a legal entity. It can not speak, just like a chair and a duck cant speak. Thats an individual person speaking. Not a Poland. Person that made this video is a clown.
@nickfinestead2781Ай бұрын
So as far as this goes, would it not be a better application to be to use a Selection.Find object so you don't have to manually set the bookmarks and just replace every instance where the text is "Name:" to "Name:" concatenated with your value obtained from the prompt?
@LearningEngineercomАй бұрын
I agree with you. But the bookmark is invisible, not so easily deleted and it can't accidentally be found and removed.
@arnelbabida4313Ай бұрын
Thank you for the great tutorial. Instead of saving it to the Document folder, how I do alter the code to just produce the output in a .docx document?
@LearningEngineercomАй бұрын
In the code under the Submit button, you can get rid of the code between Me.Repaint and userInfo.Hide
@arnelbabida4313Ай бұрын
Great video but instead of saving in the document folder, how do i change the code to just product the document and not overwrite the template?
@KarenS-tm9sv2 ай бұрын
This series is very helpful, thank you! I don't understand the Save Document code at all (like, why the ampersand underscore in the middle of the input statement?) but I can copy/paste! *Is there a way to direct where the file will be saved?* I'd prefer to save to my desktop. Thanks again Michael!
@KarenS-tm9sv2 ай бұрын
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?
@LearningEngineercom2 ай бұрын
You can edit the template. When you open it, don't let the macro run.
@KarenS-tm9sv2 ай бұрын
@@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! :)
@BrettDaly2 ай бұрын
This was fantastic! Possible to do a video or provide a formula to add for Footers?
@kisembojojo55562 ай бұрын
You are not serious mister
@ozzynotwood2 ай бұрын
Hello. I downloaded this & the form doesn't appear. I downloaded this from your google drive & suspect google has interfered with the file, this is why I went away from Google Docs. I also noticed google only lets me download this as a normal document, not a template. Would you please be able to provide a direct download link on a service that doesn't convert files the way google does?
@LearningEngineercom2 ай бұрын
Thank you for letting me know. I will take care of this.
@ozzynotwood2 ай бұрын
@@LearningEngineercom Thanks! I Just want to modify this for my own use. I use MS-Word to make 5 labels with the only difference being the department name. I want to be able to prompt for the name so the label is correct & people avoid printing my current placeholder text.
@LearningEngineercom2 ай бұрын
@@ozzynotwood I have updated the link in the description. I had to zip up the document.
@ozzynotwood2 ай бұрын
@@LearningEngineercom Thanks for doing this. Unfortunately I got the same result. I opened the file & the code you wrote is not there.
@ser.pepper46582 ай бұрын
Only video that gets right to the point
@RichSobocinski3 ай бұрын
I'm confused about something - If you created the base document as a template would you need all that extra code for naming the file? The template ("something.dotm") would present the form as "Document1.docm" and force you to give it a name, wouldn't it? Am I missing something? Also, there is a lot of great info here, but I think a bit of editing would tighten it up a lot. I'm not sure seeing your mistakes in real time is helping anyone.
@drallisimo343 ай бұрын
thank you for your useful tutorials!
@drallisimo343 ай бұрын
very useful tutorial!
@StorKulur3 ай бұрын
❤
@nurdauletsharmetov63383 ай бұрын
But what If I had different data to auto populate, but i want it just like that, I don't want any popping up box, when I enter the document, I want it just like that, I have entered once in the document, then for it auto populate
@LearningEngineercom3 ай бұрын
So, then you want to grab let's say the nth word in your document and populate it to some bookmarks?
@nurdauletsharmetov63383 ай бұрын
@@LearningEngineercom pretty much yes, let's say document number and my partner's name, my partner's residance, card number, instead of typing it every time, i want to simply type once, in the document, without pop up box or filling forms, and after i typed it once, I want it to be in rest of the document where it indicates every one of those things. I do know I can make it happen by creating variable and assigning it to InputBox function then set it to that bookmark, but I do not really want it to pop up like box to fill in
@suzanlsaacinwhiteandmikein4124 ай бұрын
😂❤❤
@ScottCheatham4 ай бұрын
What about the reference page? Is there a video for formatting it?
@JanusTheRealDeal4 ай бұрын
Great form! However, I am doing something similar based on an Excel workbook having a (database) sheet of (many) records, for which I have created quite an extensive UserForm. What I would love to do is, once I have selected a record from the UserForm with all data at display, to populate an MS Word file with only a few selected data/fields, which I have already bookmarked in a template Word file (so as to generate a new filled-in Word file and leave the template intact, just as you do). The difference here is I am NOT working from within a UserForm linked to a Word file like you do, but, like I said, on a UserForm that picks data from an Excel sheet to be "copied" onto a Word file (located in a different path). Any clues on how to solve this?
@desoniajedmicov.90524 ай бұрын
Thank You very much bro, I've been searching for weeks on this specific tutorial about vba without hard coding on python. It actually helps me a lot because this is my workload for my OJT. Great and Precise explanation on this video. <3
@nurdauletsharmetov63384 ай бұрын
Thanks for the video, but my inputbox did not pop up when i opened a new file, could you help me what might be the problem?
@LearningEngineercom4 ай бұрын
In the editor, right click on ThisDocument and then select View code. Now you have two drop-down lists. The one on the Left should say Document and then on the right you can select either New or Open. Under New type in the name of your form and then "Show." Example: Userform.Show.
4 ай бұрын
Do you have an annotated Works Cited? Can't find up to date (or at least to 2021) facts to substantiate all the claims here. Would love to use it.
@Degamer7905 ай бұрын
Thank you for this great tutorial. I have liked and subscribed. Once we have built this project, are we allowed to use it in our personal portfolios, and do you require attribution?
@LearningEngineercom5 ай бұрын
You are allowed to use in your personal portfolio and yes, an attribution would be required.
@agatarutkowska28865 ай бұрын
Hello, I've downloaded the file from your website, but after opening the Visual Basic Editor there is now code available to edit and adjust to my needs. Could you let me know how could I do that? Thank you!
@LearningEngineercom5 ай бұрын
I just tried it, and it tells me that the file is corrupt. I will attempt to find the backup file.
@LearningEngineercom5 ай бұрын
I have uploaded a new file that should work. Please let me know if it doesn't.
@beech51906 ай бұрын
When I tried making a windowed program in SharpDevelop it suddenly broke, added item declarations a second time and did god knows what so the form just got empty even if it has quite a lot of content. Anyone knows what I/program have done wrong?
@ValleyDragon6 ай бұрын
4 years later AntiVaxxers were saying we don't need Vaccines. We just need to get healthy and stop eating French Fries.
@mattlewis57107 ай бұрын
HI, I'm wondering if you could help me on a project. I have a template for a work document (an Agenda/minutes) and i am trying to follow your instructions but i am having difficulty with some areas as what i need is slightly complex or maybe not possible but i do not have the knowledge or experience unfortunately. Please let me know if you're willing to help or if you will work on on commission to teach me what i need to know. Thanks
@Ivan_12207 ай бұрын
How to add another form or page?
@LearningEngineercom7 ай бұрын
You create another form and then use Form.Show or Form.Hide to show it or hide it.
@Ivan_12207 ай бұрын
@@LearningEngineercom pls make a tutorial on how to add page on windows form using sharp dev
@hafeeshfazulu7 ай бұрын
thank you you are a great
@hopewade37117 ай бұрын
hi guys this is if you need help with iney thing ask him I also wark with him bye
@c.danielthomas86367 ай бұрын
is there a way to highlight specific texts as the user scrolls?
@c.danielthomas86367 ай бұрын
I've been trying to create this for a while however things haven't been working out.
@LearningEngineercom6 ай бұрын
Not that I am aware of.
@happinesswatts7 ай бұрын
Is this eng123 outline
@roscmon8 ай бұрын
I'm so confused I don't even know how to articulate a question. First, you started off showing how to make a bookmark and then opened visual basic and there was a menu on the left. I didn't have that. So I thought I needed to save my doc as a template and then open the template. But I still didn't get the menu on the left. I finally figured out how to make the menu appear, but you had a form on yours. i couldn't find a form on mine. Then you made another form so I figured that would help because that's what I'm trying to do anyway. And then I couldn't see what you were doing even if I went full screen. Sigh.
@roscmon8 ай бұрын
Yeah, this was completely confusing.
@fekrabusinesssolutions8 ай бұрын
2023. And ur video rocks! Thanks a lot!
@eliorubenmc9 ай бұрын
great! thanks
@eliorubenmc9 ай бұрын
Thanks, but one question: how is the right code to do the same in case you want to run again the code to overwrite the name. when I do the same using a form but the Bookmark is erased, so my solution was to put a sample text in the template, then in code I select the Bookmark, substract 1 character at the end, then Selection.Text = TextBox.Text + " " and it works but everytime I run the code it puts one " " to the text. without the " " the Selection randomly take a character, So I feel its not right.
@fantastic76919 ай бұрын
Thank you for your video. It is great. I followed it and was able to create a custom form. The issue I have is with the Save dialog box. I get an error message when I click cancel. The error is Run-time error '5152': This is not a valid file name. Can you help with that?
@fantastic76919 ай бұрын
By the way, I forgot to mention that I tried a few lines of codes with no success. I read about the If and End If statement but could not succeed with the Cancel button. Can anyone help?
@joshzemmin719310 ай бұрын
🤣 Promo-SM
@zososound11 ай бұрын
Is there no way to add midi to it?
@yuelinxie572111 ай бұрын
My .Value yielded Compile Error, Method or data member not found? Does anyone know what's going on?
@angelapace377311 ай бұрын
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.
@LearningEngineercom11 ай бұрын
I copy the code but then explain what it means.
@BasitAli-se8cg Жыл бұрын
I need a working template for work. will you help me or create it for me?