e-mail form excel useing IF formula

P

Pindacko

Joined
Apr 26, 2006
Messages
3
Reaction score
0
Could anyone help get this to work . Can't seem to get auto_run sub to go. In excel
bowdown.gif




Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" = "89" Then auto_run
End Sub
Sub auto_run()
ActiveWorkbook.SendMail _
Recipients:="(e-mail address removed)", _
Subject:="Try Me " & Format(Date, "dd/mmm/yy")

End Sub
 
Last edited:
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Complex date VBA - insert a certain weekday 5
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Can Save be added to this! 3
Trying to run excel vba code when cell value changes from empty to entered value. 1
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Excel Msgbox runing beyond posted cell range. 1
Restricting Cell entry to certain letters 7

Back
Top