You can't. The formula should be a formula, although you could just populate
its value with the text of the message.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kim-Anh Tran " wrote in
message ...
How do I change the Target.Formula="" to calling an alert message?
My appreciation in advance for any help!
Kim-Anh

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 45 And Target.Row<55 And Target.Column = 20 Then
Select Case Target.Formula
Case "x"
'allow this
Case ""
'allow this
Case Else
'reset to nothing
Target.Formula = ""
End Select
End If
End SubTarget.Formula=""


---
Message posted from http://www.ExcelForum.com/