vba - VBA 用户窗体中的 VLookup - 字符串查找值

Question

我在 VBA 用户窗体中遇到了 vlookup 函数的问题。Using below code it only seems to work when it is numeric value, however I have got values like G9000 which when selected throw error back I have tried to cast it as string but mismatch error comes up. 网上有多个关于该主题的主题，但在我的情况下似乎不起作用。我正在使用它来使用更改事件更新其中一个框中的值。我究竟做错了什么？

Private Sub cb_safety_observers_id_Change()

With Me
.tb_safety_observersName = Application.VLookup(Val(Me.cb_safety_observers_id), employeeSheet.Range("emp_list"), 2, 0)
End With

结束子

.

标签： vbavlookupuserform