Is there any way to get this to work?

ComboBox1 has an employee's name. Employee List is not the active worksheet.




If Range("$A$3") = "Monday" Then

TextBox4.Text = VLOOKUP(ComboBox1.Value,'Employee
List'!$A$4:$H$1000,3,FALSE)

End If