Hi Greg,

The following allows for the pressing of cancel to be recognised - if
you want further explanation have a look a the link in the code:

'To end sub if "cancel" was pressed, sourced from _
http://www.excelforum.com/showthread...vbcancel+input
& http://vb.mvps.org/tips/varptr.asp
If StrPtr(Label1.Caption) = 0 Then
GoTo ExitSub
Else
End If

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=539805