PDA

View Full Version : Sleeper: Select column and row(s) and change format



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:

Bob Phillips
06-05-2012, 07:31 AM
What do you have so far? Do you have the userform, does it select the Briefing and staff okay?

Can you post your workbook as is?

road runner
06-05-2012, 07:59 AM
XLD, Sorry should of attached it first time.
This is the page i'm stuck on ( all the rest removed to save file size) i have left the userform selecting the column. I used something very similar to select row just can't work out how to combine them both. Hope this helps. RR

Bob Phillips
06-05-2012, 03:48 PM
Which row are you supposed to be selecting. The 2nd list just has Staff Number.

road runner
06-06-2012, 04:05 AM
The selection on the second list can select name/ Staff number anything as long as it identifies the staff member. I had it set to staff numbers just for a test, it can select Name.