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: 79
Default Invalid call to #$#%^#

Mark,

If it is failing on the frm.show command there may be something in your
form_initialise code that it doesn't like even though the debugger appears
to stop on the show line. Try stepping the code from the .show line as a
first suggestion.

Second suggestion - sometimes VBA spits the dummy when adding just one more
element to a form. There don't appear to be any obvious preconditions for
this, but a lot of deleted elements on the form may be causing it. Get Rob
Bovey's code cleaner (from www.appspro.com I think) and run that on your
code. It will export all your forms and modules as text files, then reimport
them, removing any legacy items.

--
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Mark Tangard" wrote in message
...
Yes, I always have that. And it compiles without a peep. ;-(

--
Mark Tangard , Microsoft Word MVP
"Life is nothing if you're not obsessed." --John Waters




Ed Ferrero wrote:

Hi Mark,

Do you have Option Explicit at start of all modules?
Try compiling after you insert that statement.

--
Ed Ferrero
http://edferrero.m6.net





 
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
Run-time error '5': Invalid procdre call or argumnt - End/Debug/He akm Excel Discussion (Misc queries) 4 August 9th 09 11:26 AM
Run-time Error '5' - Invalid procedure call or argument Trefor Excel Discussion (Misc queries) 2 December 17th 07 03:32 AM
Call Center Management: How to calculate 'cost per call' Denniso6 Excel Discussion (Misc queries) 2 June 25th 06 05:01 PM
Run-time error '5': Invalid Procedure Call or Argument Nikila Excel Discussion (Misc queries) 2 February 24th 06 09:26 PM
Run-time error '5':Invalid Procedure call or argument Jan Refsdal Excel Programming 1 July 25th 03 05:14 AM


All times are GMT +1. The time now is 03:35 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"