Userform textbox value based on combobox selection

Hi
have a userform2.
There is combobox7 and next to it is textbox4.
In sheet named sheet5, in range G5:G600 there are names and H5:H600 their staff numbers.
I am trying to get staff number in textbox4 based on what I select in combobox.
I am getting an error on following code.

Please Login or Register  to view this content.

Error is ' Unable to get the VLOOKUP property of the worksheet function class'
Any help please

Kind regards

Hi Norie,
I have populated combobox by entering Row source ( Name List)
Kind regards

Hi KK1234,
maybe so

Please Login or Register  to view this content.

Hi Norie,
Thanks again. But it does not work. The same error appears.
Apology
Kind Regards

Hi Nilem,
Apology,
The same error appears.
Sorry
Kind regards

Could you please attach a sample file, where the error occurs

OK will do

Hi Norie,
Apology.
I made a mistake.
I wanted to respond to Nilem and by mistake I replied to you.
I am still trying hard.
Getting a sample book will take a day as I have to delete many things before I post sample.
Kind regards

Hi all,
I have found an easy way of doing it.
Instead of having a dependent text box with combobox, I have created another column in sheet where it is copied and havev used VLOOK function formula to populate desired data.
In this way I find it much easier to relate.
Thanks all for your kind help.
Helping selflessly , as you all do,, is a noble act and I have clicked * to thank you all.
I am closing this one as a solution has been reached.
Thanks again
Kind regards