Macro for message box based on data selected from drop-down - not hard coded

[luajambeiro]

I'm trying to create a macro that when a user selects a group from a drop-down that also appears in the table on the other sheet, a message box appears.

But I can't hard code the items in the macro so I'll try to break this down to make it easier to understand.

1 - I have a drop-down in sheet 1 with several groups
2 - I have a table in sheet 2 with parallel and master groups in columns B and C that are associated with the groups from the drop-down (also in column A of sheet 2)

I'd like a pop-up message to show if the group selected in the drop-down in sheet 1 also appears in the parallel group and/or master group columns B2:B40 and C2:C40. The pop-up would basically alert the user that the group selected has a parallel and/or master group and they need to select those in the rows below.

I found the macro below that would work if I were able to hard code the data I want the pop-up to show for, but in this case I can't as this is a dynamic table that get updated constantly.

Please Login or Register  to view this content.

I'm attaching a sample file to help explain what I need.

Thanks in advance!

[Roel Jongman]

Have a testrun with this code..

Please Login or Register  to view this content.

this will find if the selected value is in the mentioned range of B2:C40 if the value is found the messagebox will show

[Roel Jongman]

I saw a small mistake in my answer (Range B2:C40 should be Range (A2:A40) to find the group in the list.
Also your question says they need to add the groups in the rows below.. You can also show the parallel group and mastergroup found in the msgbox and ask if they should be added.

So I wrote a code to do that..

Please Login or Register  to view this content.

[luajambeiro]

This is awesome @Roel Jongman! Even better! Thanks so much for the help.