How to use multiple instances of worksheet change routine

[meprad]

Dear friends,
I am very new in VBA, please refer to attached 'test' worksheet where i tried to formulate the code but it doesn't allowing to run multiple 'worksheet change' routine for one worksheet.
In the attached, there are data validation rules set in col A, B, and C that comes up with dropdown list. I want to delete B2 whenever I change A2. This works fine with the code I have (in the absence of second worksheet change routine). Now the problem is - I want to have value inputs from Col C in such a way that every time I select items from a dropdown it returns values in the same cell separated by comma. for e.g. if I select "aa" first then I select "bb" on the same cell it will appears as "aa, bb" (separated by comma) in the same cell. I have somehow formulated code for this event too (copied from blog). But this returns error. However, codes for both events work fine if ran at a time. i want to have both working for a worksheet. How would it be possible. Appreciate your expert advice.

Regards,
meprad

[Izandol]

I think you require this:

Please Login or Register  to view this content.

[Izandol]

Thank you for rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[meprad]

Hi Izandol, thank you very much for your quick help. you nailed it down !! awesommmmee !! Thanks is just not enough for what you did .