Importing info from VBA program to spreadsheet

[Jerome]

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

 

[Tony Jollans]

Hi Jerome,

I'm not sure I understand from your post exactly what you are doing (do you
have a Userform? And where are your data if not in the spreadsheet?) but
your question seems to relate to Excel and would be better asked in an Excel
newsgroup - microsoft.public.excel.programming perhaps