LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default MsgBox instead of compile error

Hi Bob,

I am sorry . Now I see this was a misinformation. I don't know what happened
.. Now I can name it what ever I like.
Thanks again.

Kaj Pedersen



"Bob Phillips" skrev i en meddelelse
...
Really, I am surprised, that is just a label.

--

HTH

Bob

"KP" <none wrote in message
...
Thanks you very much, it works.
I figured out that in my version of Excel I had to use the word
"ErrorHandler" .
Otherwise it wouldn't work.

Kaj Pedersen



"Bob Phillips" skrev i en meddelelse
...
Try

OnError Goto errhandler

'your code

Exit Sub

errhandler:
Msgbox "Error"


--

HTH

Bob

"KP" <none wrote in message
...
Hi,

When running a macro I sometimes get an error due to the fact that the
Webpage from which I receive some updates to the macro is down.

Is it possible in stead of the well-known 'comile-error' that I can
have my own message box to pop up. At least before the compile error
message?
How should such a macro be created. I presume it should be in the
beginning of the macro.

Thanks for any suggestions.


Kaj Pedersen











 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bubble sort Error (Compile Error: Type Mismtach) Excel Monkey[_2_] Excel Programming 6 April 24th 09 12:16 AM
VBAProject name compile error, not defined at compile time Matthew Dodds Excel Programming 1 December 13th 05 07:17 PM
MsgBox compile error in Excell Jerry Dyben Excel Discussion (Misc queries) 1 October 11th 05 07:04 PM
Compile error for MsgBox copied from Microsoft training example? Jerry Dyben Excel Discussion (Misc queries) 2 October 11th 05 05:48 AM


All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"