Cancel Button

[Dusan56]

After entering data using Input Box I need exit makro. I can't use Numeric Value or String to stop makro. The only way is using Cancel Button or OK Button. Is there some way how reprogramming Buttons in Input Box to exit makro?

[ This Message was edited by: Dusan56 on 2002-05-24 04:15 ]

[PDuPre']

Pushing it back to the top to get more attention.

[Joe Was]

Without seeing your code?

Sub
'Your box code!

If Cancel = True Then GoTo myStop
End If
myStop:
MsgBox prompt:="Operator ended update, no action taken!", Title:="UpDate Stopped!"
End Sub

You can also use:
On Error GoTo myStop
'then before the "End Sub" put "myStop:"

or after your box code add:
GoTo myStop
'with "myStop:" before the "End Sub"

Hope this helps you, this is part of the Error handling and error trapping that should be in most code!

Next time post some code so we know what we are dealing with! JSW

[Mark O'Brien]

Jet Set Willy missed out his big smiley face in that last post.

So here's some to make up for it:

[Joe Was]

Mark,
I checked Dusan56's posts, only this one is listed, so I guess no code was posted?

And no I have not seen Jet Set Willy yet, its a long weekend so maybe soon. JSW