I am in the process of making a Booking System for a NetCafe. (All code is put together from what I have found on YouTube and Google - that my "level")
My starting point is a userform frmBooking which is used to register the customer.
In userform frmBooking you can delete, correct and display customer data.
If the customer wants to buy goods in the Café, the customer is marked in the listbox in userform frmBooking and with a button, customerdata is transferred to userform frmRegning.
In userform frmRegning, goods are selected which are stored in the sheet "VareDatabase" with the option of printing. So far so good.
The challenge is the status of booked computers.
The best solution would be to be able to search the status of booked computers in connection with customer registration with a search button.
Viewing booked computers in a listbox tab 2 - in userform frmBooking will be optimal (but I can not finde code for that) - alternative in userform frmReservation.
Search data is 'Date' and 'Room' independent of each other.
All data regarding the Café is registered in the sheet "VareDatabase"
All other information is registered in the sheet "Database".
/Lars DK