Help with userform input box?

Jacko058

Board Regular
Joined
Jan 13, 2014
Messages
180
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.

am6zrk.png


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))
    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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

bertie

Well-known Member
Joined
Jun 12, 2009
Messages
1,869
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

MrExcel MVP
Joined
Jan 9, 2008
Messages
14,841
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,514
Messages
5,602,089
Members
414,501
Latest member
mdhaumyu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top