Prev: Check user credentials
Next: reading and replacing just the first line of a txt or csv file XL2
From: Tacrier on 7 Apr 2010 15:44
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
From: Don Guillett on 7 Apr 2010 15:51
Right click sheet tab>view code>insert this>DOUBLE 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
dguillett(a)gmail.com
"Tacrier" <tacrier(a)discussions.microsoft.com.> wrote in message
news:C6F4761F-07C2-424A-A587-944D293B9D04(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Check user credentials
Next: reading and replacing just the first line of a txt or csv file XL2