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
Bookmarks