Error'9': Can I create a msgbox for the user?

G

Guest

I am getting an Error '9'. I know why this is happening, but the user will
not. Is there a way that I can show a msg box instead of the errorcode?
 
G

Guest

Dave,

If you have error handlers in your code, you'd be able to show a different
message for the user. for example:

Sub test()
On Error GoTo Error_Handler

Dim i(2) As Integer

i(3) = 3

Exit Sub

Error_Handler:
Select Case Err.Number
Case 9: MsgBox "Subscript out of range!"
Case Else: MsgBox "An unexpected error occurred!"
End Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MsgBox problem 3
Excel Providing user message when RED X clicked & properly closing application. 2
SetFocus problem 7
Trapping Error Message 1
MsgBox basics 7
linefeed in msgbox 2
Message Box Question 10
Subscript Out of Range Error 16

Top