Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |