Msg Box by selecting cell

[Amortcal]

Is it possible to have a Msg Box popped up by just selecting a cell? That is, can Excel be so programmed that as I select cell A1, a Msg Box pops up with a message?

[Qroozn]

What is the reason for you wanting the message box to cokme up when they click a cell?

you may find the users in here can give you a better solution if you tell us why you want to do it this difficult way?

[Ricky Morris]

Right click on the sheet tab. Click View Code. This will launch the VBA editor with the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub

add the following code after the first line:

If ActiveCell.Address = "$A$1" Then
MsgBox "Your message here"
End If

[Mark O'Brien]

Yeah, right click on the name tab of the sheet that you want the messagebox to appear on when "A1" is selected, choose "View Code" and stick in this code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

  If Target.Count > 1 Then Exit Sub

  If Target = Me.Range("A1") Then

    MsgBox "Hi"

  End If

End Sub

As for getting the messagebox to appear right next to the cell, that isn't going to happen. A comment is probably going to be your best bet. (there's another text box thingy, but I can't remember how to insert that)

[Amortcal]

Thanks guys....this worked beautifully.

[Nimrod]

If you don't want to get into coding you can also get a pop-up input message by using the "Data"..."validation"..."input message" option from the tool bar.

[James]

Hey cruzzin, "cruzzinn for a bruzzin"

easy on the freudian slip, cokme?
as i figured!


James

[Qroozn]

huh?