Пікірлер
@carlistokelvin5676
@carlistokelvin5676 9 күн бұрын
More fallacies please
@carlistokelvin5676
@carlistokelvin5676 9 күн бұрын
Great work 🎉
@carlistokelvin5676
@carlistokelvin5676 9 күн бұрын
Nice, more of these fallacies kindly
@savannahharlan8676
@savannahharlan8676 15 күн бұрын
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
@kurtjacobson467
@kurtjacobson467 23 күн бұрын
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
@aaroneakins8258 Ай бұрын
How would I do this using text box? I need to have a text box send to two or more bookmarks.
@LearningEngineercom
@LearningEngineercom Ай бұрын
I have several videos that provide instructions on how to do just that. Go to my channel.
@michaelgergen4318
@michaelgergen4318 Ай бұрын
Someone has beef with Poland lol
@LearningEngineercom
@LearningEngineercom Ай бұрын
Someone is using a strawman argument. Not Poland. Just this bad faith argument.
@georgepiet496
@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
@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
@LearningEngineercom Ай бұрын
I agree with you. But the bookmark is invisible, not so easily deleted and it can't accidentally be found and removed.
@arnelbabida4313
@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
@LearningEngineercom Ай бұрын
In the code under the Submit button, you can get rid of the code between Me.Repaint and userInfo.Hide
@arnelbabida4313
@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-tm9sv
@KarenS-tm9sv 2 ай бұрын
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-tm9sv
@KarenS-tm9sv 2 ай бұрын
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 2 ай бұрын
You can edit the template. When you open it, don't let the macro run.
@KarenS-tm9sv
@KarenS-tm9sv 2 ай бұрын
@@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! :)
@BrettDaly
@BrettDaly 2 ай бұрын
This was fantastic! Possible to do a video or provide a formula to add for Footers?
@kisembojojo5556
@kisembojojo5556 2 ай бұрын
You are not serious mister
@ozzynotwood
@ozzynotwood 2 ай бұрын
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?
@LearningEngineercom
@LearningEngineercom 2 ай бұрын
Thank you for letting me know. I will take care of this.
@ozzynotwood
@ozzynotwood 2 ай бұрын
@@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.
@LearningEngineercom
@LearningEngineercom 2 ай бұрын
@@ozzynotwood I have updated the link in the description. I had to zip up the document.
@ozzynotwood
@ozzynotwood 2 ай бұрын
@@LearningEngineercom Thanks for doing this. Unfortunately I got the same result. I opened the file & the code you wrote is not there.
@ser.pepper4658
@ser.pepper4658 2 ай бұрын
Only video that gets right to the point
@RichSobocinski
@RichSobocinski 3 ай бұрын
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.
@drallisimo34
@drallisimo34 3 ай бұрын
thank you for your useful tutorials!
@drallisimo34
@drallisimo34 3 ай бұрын
very useful tutorial!
@StorKulur
@StorKulur 3 ай бұрын
@nurdauletsharmetov6338
@nurdauletsharmetov6338 3 ай бұрын
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
@LearningEngineercom
@LearningEngineercom 3 ай бұрын
So, then you want to grab let's say the nth word in your document and populate it to some bookmarks?
@nurdauletsharmetov6338
@nurdauletsharmetov6338 3 ай бұрын
@@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
@suzanlsaacinwhiteandmikein412
@suzanlsaacinwhiteandmikein412 4 ай бұрын
😂❤❤
@ScottCheatham
@ScottCheatham 4 ай бұрын
What about the reference page? Is there a video for formatting it?
@JanusTheRealDeal
@JanusTheRealDeal 4 ай бұрын
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.9052
@desoniajedmicov.9052 4 ай бұрын
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
@nurdauletsharmetov6338
@nurdauletsharmetov6338 4 ай бұрын
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?
@LearningEngineercom
@LearningEngineercom 4 ай бұрын
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.
@Degamer790
@Degamer790 5 ай бұрын
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?
@LearningEngineercom
@LearningEngineercom 5 ай бұрын
You are allowed to use in your personal portfolio and yes, an attribution would be required.
@agatarutkowska2886
@agatarutkowska2886 5 ай бұрын
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!
@LearningEngineercom
@LearningEngineercom 5 ай бұрын
I just tried it, and it tells me that the file is corrupt. I will attempt to find the backup file.
@LearningEngineercom
@LearningEngineercom 5 ай бұрын
I have uploaded a new file that should work. Please let me know if it doesn't.
@beech5190
@beech5190 6 ай бұрын
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?
@ValleyDragon
@ValleyDragon 6 ай бұрын
4 years later AntiVaxxers were saying we don't need Vaccines. We just need to get healthy and stop eating French Fries.
@mattlewis5710
@mattlewis5710 7 ай бұрын
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_1220
@Ivan_1220 7 ай бұрын
How to add another form or page?
@LearningEngineercom
@LearningEngineercom 7 ай бұрын
You create another form and then use Form.Show or Form.Hide to show it or hide it.
@Ivan_1220
@Ivan_1220 7 ай бұрын
@@LearningEngineercom pls make a tutorial on how to add page on windows form using sharp dev
@hafeeshfazulu
@hafeeshfazulu 7 ай бұрын
thank you you are a great
@hopewade3711
@hopewade3711 7 ай бұрын
hi guys this is if you need help with iney thing ask him I also wark with him bye
@c.danielthomas8636
@c.danielthomas8636 7 ай бұрын
is there a way to highlight specific texts as the user scrolls?
@c.danielthomas8636
@c.danielthomas8636 7 ай бұрын
I've been trying to create this for a while however things haven't been working out.
@LearningEngineercom
@LearningEngineercom 6 ай бұрын
Not that I am aware of.
@happinesswatts
@happinesswatts 7 ай бұрын
Is this eng123 outline
@roscmon
@roscmon 8 ай бұрын
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.
@roscmon
@roscmon 8 ай бұрын
Yeah, this was completely confusing.
@fekrabusinesssolutions
@fekrabusinesssolutions 8 ай бұрын
2023. And ur video rocks! Thanks a lot!
@eliorubenmc
@eliorubenmc 9 ай бұрын
great! thanks
@eliorubenmc
@eliorubenmc 9 ай бұрын
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.
@fantastic7691
@fantastic7691 9 ай бұрын
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?
@fantastic7691
@fantastic7691 9 ай бұрын
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?
@joshzemmin7193
@joshzemmin7193 10 ай бұрын
🤣 Promo-SM
@zososound
@zososound 11 ай бұрын
Is there no way to add midi to it?
@yuelinxie5721
@yuelinxie5721 11 ай бұрын
My .Value yielded Compile Error, Method or data member not found? Does anyone know what's going on?
@angelapace3773
@angelapace3773 11 ай бұрын
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 11 ай бұрын
I copy the code but then explain what it means.
@BasitAli-se8cg
@BasitAli-se8cg Жыл бұрын
I need a working template for work. will you help me or create it for me?
@user-sw2xj7zn7s
@user-sw2xj7zn7s Жыл бұрын
Thanks for everything, you made my day.