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. 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.

Could anyone help?

Thanks so much, Jerome