Vlookup in VBA not working properly with Forms

[LoveCandle]

Hi everyone,

I have a VBA form with two ComboBoxes >>

I used the following code with ComboBox1:

Please Login or Register  to view this content.

It is working perfectly,

While using the same code with ComboBox2 is not working at all and gives me a Run-Time error 1004.

This is the code used with ComboBox2:

Please Login or Register  to view this content.

I hope that you can help me solving this problem,

Thank you in advance,

bye,

[royUK]

I ssggest that you lok at the VBA .Find method instead.

The other problem will be that the changes will continue tiggering each other.

Combobox1 change event triggers combobox2 change event, which will then change combox1

[LoveCandle]

Thank you MR. royUK for your reply and advice, but actually I tried may other ways and tested many codes to reach my goal but unfortunately I faild.

So, can you please help me finding a replacement code that would solve my problem and make me reach my goal.

Thanks,

[royUK]

I think you will need to address the problem of two interacting combobox changes first. Try attaching the workbook.

[LoveCandle]

Thank you Mr. RoyUK for you interest and you man download my file from the following link:

http://www.2shared.com/file/3862791/...est_From3.html

bye,

[LoveCandle]

The link attached with my previous post was worng, I already corrected it.

Thanks,

[royUK]

I'm not sure why you are using a second cobobox, but check this amended code

Please Login or Register  to view this content.

I would replace combobox2 with a textbox or label

[LoveCandle]

Thank you Mr. royUK .. that is exaclty what I need,, by the way I have used Cells function for the same purpose in another code, but I don't no what made me stick to Vlookup Worksheet Function this time to reach my goal.

Any how,, thanks alot again for your help,