macro

[kevin carter]

Hi
we have a macro that runs from a user input
problem is if a user pressess the 'ESC' key it stops the macro
is there any VB code that can catch this ie disable the 'ESC' key while
macro is running


thanks in advance


kevin

 

[Bernie Deitrick]

Kevin,

You catch it by assigning the returned value to a variant, and then
testing the varinat's value:

Dim myVar As Variant
myVar = Application.InputBox("I'm WAITING! Enter Something!")
If myVar = False Then
MsgBox "Cancel or Esc was pressed."
ElseIf myVar = "" Then
MsgBox "You entered nothing, but pressed OK."
Else
MsgBox "You entered: " & myVar
End If

HTH,
Bernie
MS Excel MVP

 

[kevin carter]

thanks

Kevin,

You catch it by assigning the returned value to a variant, and then
testing the varinat's value:

Dim myVar As Variant
myVar = Application.InputBox("I'm WAITING! Enter Something!")
If myVar = False Then
MsgBox "Cancel or Esc was pressed."
ElseIf myVar = "" Then
MsgBox "You entered nothing, but pressed OK."
Else
MsgBox "You entered: " & myVar
End If

HTH,
Bernie
MS Excel MVP