Creating a userform in MS Word and using it to insert information into a bookmark

preview_player
Показать описание
In this video, I explain how I created a document that utilizes a userform in MS Word using the Developer tab and Visual Basic.
Рекомендации по теме
Комментарии
Автор

Thank you so much for this. I have created several template documents I use all the time with your help. It has saved me hours of manually inputting names and dates that I would always miss before.

Tahehe
Автор

Thank you for this video! Your example led me to FormFields which I'm using in my Word 2013 document instead of Bookmarks. I never would have arrived at this solution without your video.

ScottPantall
Автор

2023. And ur video rocks! Thanks a lot!

fekrabusinesssolutions
Автор

Super helpful... Can't thank you enough brother

coopercreativemedia
Автор

Thank you for teaching me how to do this. We use Word to print labels for our moulding samples and typing out a different stain color each time we need a new label is tedious.

onihonker
Автор

Great tutorial, thank you. I'm actually stuck on how to use one of the values a user has entered multiple times within a document i.e. enter a name once and use that name multiple times.

If you have any thoughts on that it would be much appreciated.

IanWitts
Автор

Hi, in your first line of code what is "lname"? If is the Bookmark name what is "fname" doing in the next line? I am very confused. I thought the Bookmark name was the one in brackets? And what is the Me in the Me.TextBox1?

nickdenton
Автор

Thank you for the swift response! In Word 2013 it *appears* to take the formatting of the initial bookmark and copy it to all cross-referenced areas.

That said, it's probably just me being stupid!

IanWitts
Автор

wow! You are the best! Thank for the video!

alejandroatencio
Автор

It would be nice if this tutorial began by informing the viewer you must have significant knowledge and experience with these specific operations to understand what is happening.

rachaelbackdoor
Автор

It doesn't work for me. When I create a form (UserForm1) and call it from autonew (Userform1.Show). I get the error "424" Object not found.

mrbob
Автор

Before I go too far down the rabbit hole is there a way to set a bookmark within a one of these? If not, there may be a better way to do what I want to do. I want to include a certain section only in certain circumstances, but that section also contains text that I'd like to autofill. I.e. if my report requires the inclusion of a common element and that common element contains a variable such as a report outlining say the use of a plot of land, I say farm, it autofills a wall of text about farms, and then I also want to say specifically cattle versus horses or sheep within that wall of text.

daltonhubbard
Автор

Can you help me with my assignment. This is what I have to do:
•An application is needed to customise the footer of report documents with the user’s department name:
He would like you to incorporate the use of a VBA form.
The user must be offered a choice of departments (including an option for the Director), with the selected Department being added to the footer without destroying the text already in the template’s footer.

icysaracen
Автор

I am using Word 2010.
I have created macro enabled template to fill students form using info by you in this video.

Now I wanted:
1: to use saveAs command such that the fileName becomes value in textbox1.

2: to make the document ready for the next student, after saving the first one.

Please guide how can I do these?

JK-hmlf
Автор

Thank for your help bro I owe you one.

Greetings

adrianruizgonzalez
Автор

Thanks for these tutorial. I love VB but making codes gives me a hard time. I like exploring... How to clear the document if I want another data to be formatted? Let's just add a clear button if client made a mistake or for you instead makes editing...

Ramper
Автор

Is there a way to have a UserForm created with a Submit button, that when clicked will enter the entire contents of the UserForm into my Word Document? (including not just textboxes, but also radio buttons, checkboxes & labels)

lisamykytik
Автор

You have to go into Visual Basic under the developer tab. The name of the form should be in the list on the left.

LearningEngineercom
Автор

Could I use the 'userform1.show" in a macro button to make the form pop up at the click of a button?

Tom-ivzv
Автор

For multiple entries of the same data, I tried copying the Bookmark to an additional location but this just removes the original bookmark. Do I need to change the Range in someway?

bomberbrown