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.