VBA Error Handling

[GRCArizona]

Mr. Excel -

I'm getting an error in VBA

Compile Error:
can't find property or library.

I know why I'm getting it, but does anyone know if this has an error #? And, can anyone tell me some error-handling code that I could have a MsgBox prompt display the message: "Incorrect credentials"

thanks for the help!

GRC

 

[fredlo2008]

Try this

On Error GoTo Error1 'place this line reight before the error occurs



'the rest of the code here




Error1:


MsgBox "Incorrect credentials"
Exit Sub