error in worksheet_change event

[dorabajji]

Hi,
I have a sample file, where i have macro to get a vlookup as dropdown using custom function exist..
i want the trigger event to fire, when the user manually chooses from the dropdown and not when macro runs..
But this event interfere with macro and it hampers its functioning..

[huuthang_bd]

Hi dorabajji,

Worksheet_Change event hasn't Cancel parameter. It has only Target parameter.

[dorabajji]

Hi dorabajji,

Worksheet_Change event hasn't Cancel parameter. It has only Target parameter.

Hi huutang,
Is the event , I used wrong?
My purpose is to the event should not interfere with the existing macro..
And when the user selects option from drop-down, then the event should copy paste the values to col 5

[yujin]

As huuthang_bd said, try to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and see what happens.