Scheduling tool - Userform information saved to a specific date / time

[gr8trthanu]

I am currently creating a scheduling tool for a friend's clinic.

When userform "schedule" is completed by the employee - vba should save the data to a spreadsheet entitled Schedule.

If the date and time is already booked a message box should appear stating so.

5 appointments can be made at a time with an error message stating which appointment time is already booked

The fields on the form are as follows
Patient ID (text box)
Last Name (text box
First Name (text box
Phone # (text box)

Apointment # 1
Date (textbox)
Time (textbox)

Apointment # 2
Date (textbox)
Time (textbox)

Apointment # 3
Date (textbox)
Time (textbox)

Apointment # 4
Date (textbox)
Time (textbox)

Apointment # 5
Date (textbox)
Time (textbox)

The spreadsheet would look similiar to below with date already populated in column A for 365 days and time already populate from 8:00 to 5:00 in 20 mins intervals
Column A Column B Column C Column D Column E Column F
Date Time Patient ID Last Name First Name Phone Number
01/01/2016 8:00
01/01/2017 8:20
01/01/2017 8:40
01/01/2017 9:00
and so on.....

Can anyone point me in the right direction or provide some help here.

This is for a friend doing a start up company so I am trying to help her.

thank you

 

[mumps]

It is always easier to help and test possible solutions if we could work with your actual file. It will save having to type in dummy data and creating a dummy user form. Perhaps you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.