LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default Possible Bug in Excel UserForm?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform to enter values and shown in same userform in list helmekki[_104_] Excel Programming 0 November 19th 05 03:23 PM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com[_2_] Excel Programming 3 May 6th 05 05:44 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM
Linking userform to userform in Excel 2003 missmelis01 Excel Programming 2 August 27th 04 08:07 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"