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, 13 views)