Basically, i have a cinema seat booking form and can not find a way for the form to add the right amount of values into the spreadsheet.
Screenshot of form and worksheet (seat numbers on the left)
If all 5 seats are being booked, i want the form to add the Values from the combo box into the correct places. If it has only seats 1 to 4 being booked, i only want it to add those in, and so on...
The text box in which the seat numbers are entered are called "txtSeat#"
The combo box is called "ListType#"
# = numbers 1 to 5
I have got the form to get to the right date/time, so now its just this which is bugging me
I hope this post makes sense
Screenshot of form and worksheet (seat numbers on the left)
If all 5 seats are being booked, i want the form to add the Values from the combo box into the correct places. If it has only seats 1 to 4 being booked, i only want it to add those in, and so on...
The text box in which the seat numbers are entered are called "txtSeat#"
The combo box is called "ListType#"
# = numbers 1 to 5
I have got the form to get to the right date/time, so now its just this which is bugging me
I hope this post makes sense