road runner
06-05-2012, 07:14 AM
This is my first post so forgive me for any silly mistakes.
I have a sheet contain a list if training session from H1 to IV1.
In column A (a8:down) it has the list of people.
I was hoping to use a Userform with two listBox(s) to ask the user to select the Briefing and the staff who attended and and it would change the cells at the intersection from NO to YES. I have managed to select Rows or columns but not both together.
Any help would be appreciated.
Thank You in advance:
I have a sheet contain a list if training session from H1 to IV1.
In column A (a8:down) it has the list of people.
I was hoping to use a Userform with two listBox(s) to ask the user to select the Briefing and the staff who attended and and it would change the cells at the intersection from NO to YES. I have managed to select Rows or columns but not both together.
Any help would be appreciated.
Thank You in advance: