I need help creating a pop up box to input data, I've searched around but it don't make much sense and I can't get it to work..
Here's a picture of what I'm currently doing to learn.
I'm wanting a pop up box to fill in the data in cells G to Q.
Here's what I need it to do
Here's the actual file, If anybody can help that would be highly appreciated !!!
Thank you!
https://www.sendspace.com/file/2mbwlg
Here's a picture of what I'm currently doing to learn.
I'm wanting a pop up box to fill in the data in cells G to Q.
Here's what I need it to do
- Booking No - I need it to find the next blank cell (in this case G5) then +1 from the previous cell (G4) so it'll automatically add 'Booking No - 4' and on the input box this can't be edited but to display it?
- Guest Name -Just a simple input box to input the guest name at side of the Booking number.
- Guest Contact No - Same as, Just to add the guests contact number
- Booked By - If possible a userform dropdown.. So from this you can select the employee by a drop down menu from cells ='Room Reservation'!E2:13
- Date Booked - Date booked could be the same as Booking No but with todays 'todays' date?
- Check In - Check Out - Either a pop-up calendar or just a basic input box
- Adult Guests - Children Guests - Just a small numbers box
- Room No - Same as 'Booked By' but from the cells ='Room Reservation'!B2:B3
- Room Type - Could this be done by a VLOOKUP ? I currently use
Code:
=IF(ISERROR(VLOOKUP(P2,B$1:C$65536,2,FALSE)),"",VLOOKUP(P2,B$1:C$65536,2,FALSE))
Here's the actual file, If anybody can help that would be highly appreciated !!!
Thank you!
https://www.sendspace.com/file/2mbwlg