RE: userform and error excel has stopped working

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


i put the error option to all errors but it stays the same. when i try to
debug, the error doesn't show. it only happens when i do a save (of the data
) and open the (new) file again (so that the code can be executed).


"Joel" wrote:

You need to put a break point at the SUB line in the userform and then step
through the code. You probably have to put a break point at the start of
each of the SUB's in the userform to find the problem.

"hekske" wrote:

hi,

i have created a userform in excel. when i debug it it works fine. when i
click on the button "Save" (does a save as) and rename the file until here no
problem. but when i try to open the newly saved file it gives an error like
"excel has stopped working ....". when i place a messagebox just before the
form.show command, it displays the messagebox and when the command form.show
needs to be executed the error appears again and i can close excel. if i open
de file without executing the code and change something (for exemple add an
empty line) in the code and save it, the file works again. like this i can
not send this userform to be used by our offices.
what could be the problem????? has anyone got an idea?
.

Relevant Pages

  • Re: Show method stops macro
    ... When you show a UserForm in Excel 97, Excel displays it as a *modal* form. ... That means the calling code will stop executing until you hide the Userform ... > Public Sub SomeProcedure() ...
    (microsoft.public.excel.programming)
  • userform and error excel has stopped working
    ... i have created a userform in excel. ... form.show command, it displays the messagebox and when the command form.show ... de file without executing the code and change something (for exemple add an ... not send this userform to be used by our offices. ...
    (microsoft.public.excel.programming)
  • RE: userform and error excel has stopped working
    ... You need to put a break point at the SUB line in the userform and then step ... i have created a userform in excel. ... form.show command, it displays the messagebox and when the command form.show ... de file without executing the code and change something (for exemple add an ...
    (microsoft.public.excel.programming)
  • Re: Debugging Suggestions
    ... I have set breakpoints, but they don't execute in the ... Did you put the complete path to Excel into the Project Settings Debug ... Also put a test spreadsheet on the command lines arguments in the Settings. ...
    (microsoft.public.office.developer.com.add_ins)
  • Re: VB 6 debugging on Vista
    ... I have several older apps in VB6 that I am still working with. ... I find that when I debug, if I am stuck in a loop, Vista will not ... If you're running in the IDE then as far as I know VB is effectively behaving like an old fashioned interpreted Basic program and the "interpreter" is watching for debug input in between executing each statement, even if your code is in a tight loop. ...
    (microsoft.public.vb.general.discussion)