Message Pop Up

[waterballoon]

In a column I have a drop down menu and would like for the message to come when one of those choices is chosen

Don't even know where to start...

Thanks ahead of time!

 

[GTO]

You mean you have data-validation? Is it from a list, a formula, or???

 

[waterballoon]

Yes sorry, it's a data-validation from a list.

 

[GTO]

Okay, then let's assume the DV is in B1, like:

Excel Workbook
	A	B	C	D
1	My List:	Val 3		Val 1
2				Val2
3				Val 3
4				Val 4
5				Val 5
Sheet2

Excel 2010

In the Worksheet's Module:

Option Explicit
    
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count = 1 And Not Application.Intersect(Target, Range("B1")) Is Nothing Then
        If Target.Value = "Val 3" Then
            MsgBox "Some msg...", vbOKOnly, "My Titlebar Caption"
        End If
    End If
End Sub

Hope that helps,

Mark

 

[waterballoon]

Thanks!

Don't know what I'd do without you guys.