Have tried several examples from various websites, actually copying them
and pasting them in vba, and can't get them to run at a particular
time.

Is there a setup setting I need to change?

Any suggestions as to why these won't work?

latest...
Sub My()
'
' Macro3 Macro
' Macro recorded 6/22/2004 by Administrator
'run at 11:30 am
Application.OnTime TimeValue("13:00:00"), "showAlert"
End Sub
Sub showAlert()
MsgBox "Time's up!"
End Sub

As you can see simple things...

Thanks in advance


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

I got it to work, but not before saving the file. So after pasting the
code, save the file, then run the macro. This should fix your problem.

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

"Soonernut " wrote in message
...
Have tried several examples from various websites, actually copying them
and pasting them in vba, and can't get them to run at a particular
time.

Is there a setup setting I need to change?

Any suggestions as to why these won't work?

latest...
Sub My()
'
' Macro3 Macro
' Macro recorded 6/22/2004 by Administrator
'run at 11:30 am
Application.OnTime TimeValue("13:00:00"), "showAlert"
End Sub
Sub showAlert()
MsgBox "Time's up!"
End Sub

As you can see simple things...

Thanks in advance


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

See Chip Pearson's site for sample code that works:

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

"Soonernut " wrote in message
...
Have tried several examples from various websites, actually copying them
and pasting them in vba, and can't get them to run at a particular
time.

Is there a setup setting I need to change?

Any suggestions as to why these won't work?

latest...
Sub My()
'
' Macro3 Macro
' Macro recorded 6/22/2004 by Administrator
'run at 11:30 am
Application.OnTime TimeValue("13:00:00"), "showAlert"
End Sub
Sub showAlert()
MsgBox "Time's up!"
End Sub

As you can see simple things...

Thanks in advance


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