Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet

Hi All,

Being a real unexposed sort to VBA/macros I'm stuck & would appreciate any basic direction/assistance.

I have a staff leave planner spreadsheet. When the name of the person, leave type & dates are generated I want the 'key' (a letter) to be entered into the spreadsheet date area to update manning numbers and hours (range FP7-GE7 & FP50-GE50 in worksheet). There are 4 worksheets, three of which are for various shifts (so I can alter data to suit each worksheet as soon as I get one worksheet functioning) and the forth is a index key. I need the letter of the related leave type to correspond to the selected leave type in the Userform to then appear in the calendar area of the spreadsheet (so that day/person is not counted) and I can then set up conditional formatting to better display this on the spreadsheet.

I am completely out of my depth as to how to enter the Userform code to generate the data based on the persons name and the leave type into the dates entered. Because I am so green I don't even know how to properly setup initialization of the form.

If you know of any good information websites or tutorials on youtube I'd love to look at them. I've spent so many hours on google and I'm not getting anything but more confused.

I hope this is enough information. Spreadsheet is attached, current coding (or lack of) below:

Private Sub ComboBox1_Change()

End Sub

Private Sub ComboBox3_Change()

End Sub

Private Sub CommandButton6_Click()

End Sub

Private Sub DTPicker1_Enter()
DTPicker1.Value = Now()
End Sub

Private Sub CommandButton7_Click()

End Sub

Private Sub CommandButton8_Click()
Unload Me
End Sub

Private Sub DTPicker2_Enter()
DTPicker2.Value = Now()
End Sub

Private Sub Frame1_Click()

End Sub

Private Sub UserForm_Click()

End Sub

Private Sub UserForm_Initialize()

End Sub


Again many thanks for any help - Marie

Hi Marie

I made a start on this for you.

The only button that I haven't programmed is the New Name

I'd need to know where the ID number would come from and what you would want in the database.

Enjoy

I have modified this slightly to make it a lot more intuitive.

Thank you Mehmetcik, this has given me a great starter point beyond where I was!

You're certainly far cleverer than I Thank you so much for your time and assistance!!