Posts by oijoii

    Re: Time In And Time Out Using Userform


    Hi Apo,


    I'm trying to use and copy the codes in the timesheet sample in this thread with the file im working on right now. but the code is not working and gives me an error: Compile error: Variable not defined.


    Private Sub ComboBox1_Change()
    On Error GoTo Handler:
    txtEmp.Value = Application.WorksheetFunction.VLookup(ComboBox1.Text, Sheets("PC_Laborer").Range("A1:E13"), 2, 1)
    empLabel.Caption = Application.WorksheetFunction.VLookup(ComboBox1.Text, Sheets("PC_Laborer").Range("A1:E13"), 4, 1)
    Image1.Picture = Application.WorksheetFunction.VLookup(ComboBox1.Text, Sheets("PC_Laborer").Range("A1:E13"), 5, 1) 'Display Photo
    Handler:
    End Sub


    can you help me with this one please?

    Files

    • test.xlsx

      (41.63 kB, downloaded 83 times, last: )