Help with userform input box?

[Jacko058]

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

• 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

  =IF(ISERROR(VLOOKUP(P2,B$1:C$65536,2,FALSE)),"",VLOOKUP(P2,B$1:C$65536,2,FALSE))

  to find the room type from the room number.

Here's the actual file, If anybody can help that would be highly appreciated !!!

Thank you!

https://www.sendspace.com/file/2mbwlg

 

[bertie]

Excel comes with a built in data form which may suit your needs.

Click on the help file and type in; what happened to the data form.
Follow the instructions to add the data form icon to your quick launch toolbar.
Click on any populated cell in your spreadsheet you want the form to refer to, e.g. any cell in the range "G2:Q4"
Click on the data form icon.
And, how simple was that.

Sadly, it won't give you a drop down box for the Staff_id.

 

[MickG]

Try this Example file:-
https://app.box.com/s/qql1jidkrq8vshfzaqqv

 

[Jacko058]

Try this Example file:-
https://app.box.com/s/qql1jidkrq8vshfzaqqv

Thanks Mick thats exactly what I need!

I do get error's though when I click the dates?

So is it possible to disable this unless the "Checked in/out" box is selected.
Also, If you select room 1 it automatically pulls the room type?

 

[MickG]

Have a play with the below, see what other problems there are !!!
NB:- The idea is to Click an "In or Out" box , then select a date, for the Box to fill with that date.
You can retrieve selected booking for alteration, where shown, then re -Update the Register.!!!
A Msgbox will now shows if "In Out box" is not selected when calender date is selected , and also if one of the field has not been Filled in , when you Click "Update" !!!
https://app.box.com/s/jnp1xcbe1xqyz6wj8p18