![]() ![]() ![]() At the end of the form is a 'Submit' button (code shown below) which when clicked the user is prompted to confirm they are ready to submit the assessment, and if 'Yes' the form writes the values from the UserForm controls to a relevant bookmark in the document, replaces some of the bookmarks with enclosing bookmarks, saves the document, composes an email and attaches the document ready for sending, then resizes the window and closes MS Word.Navigation of the form is achieved with 'next' and 'previous' command buttons.The UserForm is 'locked' where the only way to close it is to force close MS Word OR to click a command button and enter the correct password.On open, the document 'hides' and displays a UserForm to complete the required questions, including your name (Which is shown in the below sample code).I have a MS Word document which is a 10 question assessment made up of a table at the top containing details such as your name and table sections below, each for 1 question and answer and as required bookmarks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |