Arash_The_A_Level_Student
New Member
- Joined
- Feb 16, 2002
- Messages
- 38
I want my excel template after every 250 processes to notify me a message (eg. Save To CD writer) does anyone know how to do this?
This process, is this done with a Macro?On 2002-02-28 12:32, Arash_The_A_Level_Student wrote:
A process for example I data on a built-in data form and it copies that sends it to my invoice, well after every say 100 times it does this I would like it to notify me that it has done 250 process with a message box
On 2002-03-01 11:05, Joe Was wrote:
Right click a sheet tab lable, then select "View Code" from the list on your left dubble click "ThisWorkBook" and paste a copy of this code on to the sheet on your right. Hope this helps. JSW
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
Dim myTest As Integer
Static x As Integer
'By: Joe Was, 2/2002
x = x + 1
myTest = x
If myTest >= 250 Then
MsgBox "Time to Save"
Else
GoTo myEnd
End If
myEnd:
End Sub