gr8trthanu
Board Regular
- Joined
- Nov 14, 2008
- Messages
- 103
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
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