Write to built in document properties with a User Form

**TSkyla** · 11-18-2019, 12:36 PM

Hi all,

Is it possible to write to the built in document properties with a User Form? I'm trying to create a form that pops up when a document is opened with two text boxes, named "Proj_num" and "Client_name".

When the user clicks the "OK" CommandButton, I want the value in "Proj_num" to write to the built in document property "Subject", and the "Client_name" to write to the property "Company".

Note -- I'm very new to VBA. So far I've only been able to create the form with the text boxes and the command buttons. The form pops up when the document is opened and the form closes when I click the Cancel command button, so that part is working. I need help with the code for the "OK" command button.

Thanks!
Tim

**6StringJazzer** · 11-18-2019, 02:30 PM

Welcome to the Forum TSkyla!

I have not tested this but would be happy to do so if you provide your file (instead of a picture). The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Please Login or Register  to view this content.

**TSkyla** · 11-18-2019, 02:45 PM

Hi - thanks for the reply. I've tried your code and am getting an error. I've attached the file.

Tim

**mjr veverka** · 11-18-2019, 03:16 PM

Change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and everything will work

... a small "slip of the tongue"

**TSkyla** · 11-18-2019, 03:23 PM

Perfect, thanks!

**6StringJazzer** · 11-18-2019, 05:02 PM

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

If you solved your own problem, please provide your solution so that somebody seeing this thread in a search for the same problem will see how it was solved.