Hiya all.
So far I have this

Private Sub SubmitSwipe_Click()

If Sheets("Introduction").Range("F13").Value = "" Then
DoErrorMsg("NoSwipe")
Else

Submitted = Sheets("Introduction").Range("F13").Value

DoSwipeCheck (Submitted)

End If
End Sub


But what I would like to do is instead of having a button to press that
does the above I would like it so once the cell F13 has had its value
entered it automatically executes the above code.
The reason for this is the value of F13 is done by a swipe card. Which
once its value is entered the swipe also creates either a newline or
"enter" on its own ... which I thought could be used instead of having
to press a button, if you know what i mean.


thx


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080114-0, 14/01/2008
Tested on: 14/01/2008 07:49:13
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com