Hi i am trying to determine if userform tickboxs are populated
but cant get the code right
userform is data_capture_sheet
checkbox = tick1
Textbox = short_shift
Textbox = overtime_hrs
'*********************************
'with named ranges this works
ElseIf Not IsEmpty(Range("sixp_sixa")) And IsEmpty(Range("short_shift")) And Not IsEmpty(Range("overtime")) Then
'***************************************
'Shift input
If data_capture_sheet.tick1 = True And Not IsEmpty(data_capture_sheet.short_shift) And IsEmpty(data_capture_sheet.overtime_hrs) Then
Cells(r, 3) = "6am to"
Cells(r, 4) = "06:00"
Cells(r, 9) = data_capture_sheet.overtime_hrs.Text
Cells(r, 11) = "0:20"
Bernie
but cant get the code right
userform is data_capture_sheet
checkbox = tick1
Textbox = short_shift
Textbox = overtime_hrs
'*********************************
'with named ranges this works
ElseIf Not IsEmpty(Range("sixp_sixa")) And IsEmpty(Range("short_shift")) And Not IsEmpty(Range("overtime")) Then
'***************************************
'Shift input
If data_capture_sheet.tick1 = True And Not IsEmpty(data_capture_sheet.short_shift) And IsEmpty(data_capture_sheet.overtime_hrs) Then
Cells(r, 3) = "6am to"
Cells(r, 4) = "06:00"
Cells(r, 9) = data_capture_sheet.overtime_hrs.Text
Cells(r, 11) = "0:20"
Bernie