Unable to run macro on every dropdown item

[Datcy]

Hi

I want that a message box should appear on selecting each item from the dropdown list. However, not able to do so. Only one msgbox pops up when I hit delete across any cell in the sheet.

Please find the code below:

Please Login or Register  to view this content.

Please suggest

[arlu1201]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

[arlu1201]

Try putting the code in the worksheet_selectionchange event.

[Datcy]

Thanks for the code tagging.
I tried worksheet_selectionchange event, however, now at every click of the mouse I get the msgbox "Hi there"
Not what i desire

[arlu1201]

Then you can specify the target cell like

Please Login or Register  to view this content.

[Datcy]

sry its still not working....could be provide me the code
pls

[arlu1201]

Here it is

Please Login or Register  to view this content.

Sometimes you dont see the error till you test it.

[Datcy]

Its working fine now....Many thanks for ur help

[arlu1201]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

[Datcy]

Hi,

I continuation with the above post, I have one more question. what if I want to prevent the same menu item being selected again such that the same macro is not run again....In short, I want to disable the dropdown menu item being selected again.

Could you let me know a solution to that?

Many thanks in advance..

[Datcy]

Hi,

I continuation with the above post, I have one more question. what if I want to prevent the same menu item being selected again such that the same macro is not run again....In short, I want to disable the dropdown menu item being selected again.

Could you let me know a solution to that?

Many thanks in advance..