(Solved) – Excel Dropdown Box and then MSG Prompt


I am currently working on a excel spread sheet, but I have hit a brick wall and I hope that some one can help me:

I have 5 values in a drop box which covers cells C7:AD18, the idea is that when a user selects one of the users select for instance Value1 a msgbox will popup “Thanks for Selecting Value1”

The issue I have incountered is that the only way I can do it is by setting up the programming for EACH cell:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C7")) Is Nothing Then
   Select Case Range("C7")
      Case "Value1": Macro1
      Case "Value2": Macro2
      Case "Value3": Macro3
      Case "Value4": Macro4
      Case "Value5": Macro5
   End Select
End IF
End Sub

I have then had to add an entry for C8, C9, C10 Etc, I have tried to use a range of “C7:AD18” but I can’t get it to work at all, it keeps coming back to debug.

Can any one please assist me!
– Phil

Leave a Reply

Your email address will not be published. Required fields are marked *