View Single Post
 
Old 04-08-2015, 07:04 PM
Niclasfa Niclasfa is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2015
Posts: 13
Niclasfa is on a distinguished road
Default UserForm VBA coding

Ok so I have this problem that I have to find a solution for.

Basically the boss has asked me to create a User Form based on a Word 2013 template that pops up every time someone opens it.

My problem is this....
Ok, so I have created the user form based on a Word 2013 template. The user form has data entry areas. I have also created three buttons on the bottom of the form (OK, LOG, CLEAR)

I haven't created any of the macros yet because I don't really know how the VBA language works.

I have come up and with names for the macros but have not yet assigned any and I am not sure exactly how I go about doing that.

1. mcrOk:- needs to populate the bookmarks created in the template (I have attached the button but not the code to link it)

2. mcrLog:- I need this macro to append person data to the text file Latelog.txt and hide the UserForm. Obviously this will be attached to the button with the caption Log

3. mcrClose:- This macro needs to close the form and it will be attached to the user form button close

I hope this is helpful to anyone with experience in this field.

Thanks in advance for any positive feedback and or suggestions.

Last edited by Niclasfa; 04-08-2015 at 07:06 PM. Reason: repition
Reply With Quote