L
LEU
I have a macro that creates a warning table with two columns. What I would
like it to do is in the first column is load the hazard and the second column
would list the controls for that hazard. There could be more than one hazard
in the table.
The following is an example:
Column One is the Hazard
Column Two is the Controls
Column One Row One
Chemical Exposure Hazard
Column Two Row One
Avoid contact with eyes.
Avoid breathing vapor or mist.
Wash hands thoroughly after use.
Review MSDS for each chemical
Locate pressurized portable eye wash station near work area.
Use nitrile gloves when applying chemicals.
Column One Row Two
Electrical Hazards
Column Two Row Two
Inspect tools/equipment for damage prior to use. Do not use damaged tools
or equipment
Use ground fault circuit interrupters (GFCI).
How would I create bookmarks for each Row and then open a form that listed
the hazards and the appropriate controls. Then the user could pick the ones
they needed and it would load them into the table?
I hope I explained this ok.
like it to do is in the first column is load the hazard and the second column
would list the controls for that hazard. There could be more than one hazard
in the table.
The following is an example:
Column One is the Hazard
Column Two is the Controls
Column One Row One
Chemical Exposure Hazard
Column Two Row One
Avoid contact with eyes.
Avoid breathing vapor or mist.
Wash hands thoroughly after use.
Review MSDS for each chemical
Locate pressurized portable eye wash station near work area.
Use nitrile gloves when applying chemicals.
Column One Row Two
Electrical Hazards
Column Two Row Two
Inspect tools/equipment for damage prior to use. Do not use damaged tools
or equipment
Use ground fault circuit interrupters (GFCI).
How would I create bookmarks for each Row and then open a form that listed
the hazards and the appropriate controls. Then the user could pick the ones
they needed and it would load them into the table?
I hope I explained this ok.