View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond Robin Hammond is offline
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