Retrieving values from a worksheet using userform

[lui de sagun]

Hi,

It's me again asking for your help.

I created a userform (userform7) to view the existing values of a worksheet (Logs).

The last value of combobox (combobox12) prompts as a default value. The default value (combobox12) should be able to retrieve the required data from worksheet (Logs) whenever I click the View button - I tried to use the WorksheetFunction.VLookup but I guess there is something wrong with my code.

I badly need your expertise on this please. I also attached the file that I am using for your reference.

 

[Ramesh]

Instead of using vlookup, we can find the row number of the given value by using find method and accordingly populate the values...

Here is the updated file..

 

[lui de sagun]

Thanks again, Ramesh - you're such as genius!