When we get a new employee in our laboratory, their supervisor has to go through computer training with them.



We have 8 different areas in the lab and the previous creator of the training forms made 8 different forms. This was ok at the time, but when an update had to be made, it had to be made to all the forms.

What I did was take all the forms and put all the requirements from them all and incorporated into one form. (See Attached)

My plan was to then create a macro for each area that would "gray out" areas that didn't pertain to a certain section and check the N/A box.

Apparently I can't create a Macro in this way because when I start the record, I can't check any boxes or highlight text.

Is there any way you can think of that I can take all 8 of these forms and create a single form that I can create an autofill on some of the boxes depending on which area of the lab the new employee would be working?

Attached Files

Laboratory Staff Computer Training Documentation.docx (78.3 KB, 11 views)

Take a look at Create a Simple Userform. That, combined with storing your variable text as AutoText should do what you want. Note, in order to have macros, or a userform in a template, it must be stored as a .dotm.

I wouldn't be using a userform for this (although you could if you wanted).

If you want to 'grey out' a section you could do this by:
Bookmark the section you want to grey
Create a character style that has the grey attribute you want to apply
Create a macro that applies this character style to the bookmarked range
Add a macro to the ThisDocument module of the template to check the status of a CC when you exit it. This macro could be used to trigger the character style macro.

This is not something that can be recorded although elements of it can be.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thanks for the replies.

I may just have to leave this as 8 separate forms.