When i press CTRL + BREAK a msg comes on the screen.
I made this by onkey event.
however
it doesnt work when i press CTRL + BREAK on a USerform.
how can i fix it.
Héctor Miguel said:hi, john !
When i press CTRL + BREAK a msg comes on the screen.
I made this by onkey event.
however
it doesnt work when i press CTRL + BREAK on a USerform.
how can i fix it.
ask in the on-line help [vba] for the application.enablecancelkey method
hth,
hector.
thnx, but it doesn't work
hi, john !When i press CTRL + BREAK a msg comes on the screen.
I made this by onkey event.
however
it doesnt work when i press CTRL + BREAK on a USerform.
how can i fix it.
ask in the on-line help [vba] for the application.enablecancelkey method
hth,
hector.
Héctor Miguel said:hi, john !
thnx, but it doesn't work
this way it's working for me... [w/in the show userform procedure]...
Sub ShowMyUserform()
Application.EnableCancelKey = xlErrorHandler
On Error GoTo Check_Error
UserForm1.Show
Check_Error:
If Err = 18 Then Resume
End Sub
if any doubt or further informacion, would you please comment ?
hth,
hector.
__ previously on this thread __hi, john !
When i press CTRL + BREAK a msg comes on the screen.
I made this by onkey event.
however
it doesnt work when i press CTRL + BREAK on a USerform.
how can i fix it.
ask in the on-line help [vba] for the application.enablecancelkey method
hth,
hector.