Peter,

Thank you for writing! I wasn't able to duplicate the errors you
reported...and tried the form on 3 separate XP & Excel 2003 machines. I did
notice a problem in my "back" and "next" button, so I coded a fix to that and
uploaded a new copy to my server...but that did not affect the problem.

I have stepped through the code (a lot!) and the funny thing is that the
form works fine with the VBE open. No errors at all. That is currently the
workaround I am using with my survey takers.

Curious about the problems you experienced...so I tried it on another
machine...and got the errors you reported when I ran it from the browser.
Please right-click and save it to your computer before running. Once I did
that, it ran fine.


Thanks!
--
Gene


"Peter T" wrote:

> I had a quick look but didn't get very far, breaking with a errors trying to
> refer to a range names that don't exist (eg cs4a1tracker & c4a1evalbtn).
>
> Why not create the scenario you think will cause the lock up, then step
> through with F8 starting in the "FormOpen" proc. Also put a break on all
> control events and likewise step through.
>
> Regards,
> Peter T
>
>
> "Gene" <Gene@discussions.microsoft.com> wrote in message
> news:5A20AEC6-C764-46DA-AEA9-F0D3F3D86880@microsoft.com...
> > I have created an Excel multi-page userform to gather some data from end
> > users. The form is locking up Excel when a sequence of steps is followed.
> I
> > have decomposed this problem and can find no reason for the behavior. I
> need
> > an expert's assistance to determine if I need to report this as a bug or
> if I
> > am not coding this properly. I've provided detailed steps below to
> replicate
> > the problem.
> >
> > Thanks very much in advance for your help,
> > Gene Loughran
> >
> > A. Please download the Userform from my website:
> > http://www.genesyspc.com/files/UserForm_test_0.xls
> >
> > B. It has been virus scanned, but by all means, it never hurts.
> >
> > C. Use the following directions to replicate the problem:
> >
> > 1. Open the Excel UserForm File & Enable Macros
> >
> > 2. Start the UserForm by selecting "FormOpen" from the Macro list.
> >
> > 3. Click Next to go to the first "Case"
> >
> > 4. Click on the "Evaluate" button for the 2nd Alternative
> >
> > 5. Enter a number in Criteria 2 / Element 2
> >
> > 6. Click the "Return" button
> >
> > 7. Click on the "Save" button
> >
> > 8. Click "Yes" to exit the Userform
> >
> > 9. Exit Excel
> > --------------
> > 10. Open the Excel UserForm File & Enable Macros
> >
> > 11. Start the UserForm by selecting "FormOpen" from the Macro list.
> >
> > 12. Click Next to go to the first "Case"
> >
> > 13. Click on the "Evaluate" button for the 1st Alternative
> >
> > 14. Enter a number in Criteria 1 / Element 1
> >
> > 15. Click on any other function (such as Criteria 1 / Element 2
> >
> >
> > ** Excel should have locked up at this point. If it has not, repeat steps
> 6
> > - 15, replacing step 13 with step 13b, below:
> >
> > << 13b. Click on the "Evaluate" button for the 3rd Alternative >>
> >
> > ...continue with step 14 above.
> >
> > ================================================
> >
> >
> >
> > --
> > Gene
>
>
>