Thanks again Coolsid! the Code works really well, I'm just putting the final touches to the template before submitting to the 'heavy's'. I'm having slight issue with a userform I've created for it, I'm used to Word and userforms "Selection.Typetext...blah!) but it's different in Excel, I'm trying to get the below to work, but it's not liking it. any help?


Code:
Private Sub cmdOkay_Click()
Dim ws As Worksheet
Set ws = Worksheets("FlexiHours")

ws.Cells(B3, 2).Value = Me.txtname.Value
ws.Cells(E3, 5).Value = Me.txtdepartment.Value
ws.Cells(J3, 10).Value = Me.txtbalance.Value
ws.Cells(B8, 2).Value = Me.txtdate.Value

End Sub