Hi

I am new to VBA and was wondering if anyone could please help me with a

problem I have been encountering.


I am making a spreadsheet for my school's drama festival.It has a small

VBA program in it which shows the user a seating plan, which is placed
on a UserForm. He/she can double-click to book it, and the program
specifies if the person is to
be an adult or child. That 'seat' on the seating plan then changes
colour - red for adult, blue for child.


But now I want this information to be uploaded into the spreadsheet -
so on the spreadsheet it will say what seats/how many seats have been
booked. Can it see how many boxes are coloured red and blue, and then
also put on the info?


Could anyone help?


Thanks so much, Jerome