Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '5': Invalid procdre call or argumnt - End/Debug/He | Excel Discussion (Misc queries) | |||
Run-time Error '5' - Invalid procedure call or argument | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Run-time error '5': Invalid Procedure Call or Argument | Excel Discussion (Misc queries) | |||
Run-time error '5':Invalid Procedure call or argument | Excel Programming |