kieran989
03-03-2017, 11:33 PM
hi all,
I am trying to write a macro that will help me create a activity/hazard/control assessment for my field of work.. The idea is to have three lists. Activities are to be selected in listbox 1 and this will automatically populate the associated hazards and controls into listbox 2 and 3. Then the user will then select the appropriate hazards from the list and this will add further associate controls to the Listbox 3. Then the user will select the appropriate controls and eventually I will add something in that will create a risk assessment spreadsheet.
all of the activity-hazard, hazard-control and activity-control relationship matrices are on separate sheets.
I cant for the life of me figure out whats going on in my code. When the activities are selected it seems to be somewhat working.... however I cant all the associated hazards to list correctly
Can somebody please have a look and provide some comments?
note i have just named all the activitiy, hazard and control data and incremental name so as not to publish all the information.
Cheers,
I am trying to write a macro that will help me create a activity/hazard/control assessment for my field of work.. The idea is to have three lists. Activities are to be selected in listbox 1 and this will automatically populate the associated hazards and controls into listbox 2 and 3. Then the user will then select the appropriate hazards from the list and this will add further associate controls to the Listbox 3. Then the user will select the appropriate controls and eventually I will add something in that will create a risk assessment spreadsheet.
all of the activity-hazard, hazard-control and activity-control relationship matrices are on separate sheets.
I cant for the life of me figure out whats going on in my code. When the activities are selected it seems to be somewhat working.... however I cant all the associated hazards to list correctly
Can somebody please have a look and provide some comments?
note i have just named all the activitiy, hazard and control data and incremental name so as not to publish all the information.
Cheers,