Was hoping to use a Macro on the attached form, but...
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?
|