make message box appear when cell is clicked?
 

Learning vba as I go, right now I am trying to get a message box to appear on
a user form I created for staff. This is what I have so far:

Sub showMessage()
MsgBox "Press Alt-Enter to insert a new line"
End Sub

What would the rest of this code be to have the message pop up when merged
cell AE8 is selected?

Thanks in advance :)

Trina

make message box appear when cell is clicked?
 

Right click sheet tabview codeinsert thisDOUBLE click in e8:f8 to fire

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
If Target.Address < Range("e8:f8").Address Then Exit Sub
MsgBox "hi"

End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tacrier" . wrote in message
...
Learning vba as I go, right now I am trying to get a message box to appear
on
a user form I created for staff. This is what I have so far:

Sub showMessage()
MsgBox "Press Alt-Enter to insert a new line"
End Sub

What would the rest of this code be to have the message pop up when merged
cell AE8 is selected?

Thanks in advance :)

Trina