Hi Guys again,
Someone is going to kick me off this forum for asking to much questions.
I am very new at this so please bare with me. I have 2 worksheets. Now Ws 1 stores all employee data. Ws2 has a Userform that looks up an employee from ws1 in one combobox(which I figured out how to get going). The second combobox have to lookup the employees name in cbx1 and match it in ws1 and return the employee ID nr. now this is what I have so far.
PHP Code:
Dim ws As Worksheet
Dim aCell As Range
Dim aRow As Long
Set ws = ActiveWorkbook.Worksheets("Shifts")
With ws
'aRow doesn't look right to me
aRow = Application.WorksheetFunction.Match(Int(Me.EmployeeComboBox.Value), Worksheets("Data").Range("empid"), 0)
aRow = iRow + 3
Me.EmplIDbombobox.Value = .Cells(aRow, 2).Value
End With
Please help. I think "aRow" is not specified correctly but have no idea how to fix it.
Thanx guys for putting up with me, please don't kick me off!!!