Advertisement

05.19.2008 at 07:06PM PDT, ID: 23415772
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.7

Combo Box Issues

Asked by visiontraining in Microsoft Excel Spreadsheet Software, Visual Basic Programming

Tags: , ,

I have a 5 page Userform that i'm using a combobox in to alllow users to navigate. I have had a number of problems with the use of the combobox particularly if I rapidly change the pages. I think that Excel gets confused what its opening and closing.
Also, I initially had the code set to Open the new form, then unload the current form so that the user wasnt exposed to the underlying worksheet. However this proved troublesome so I went back to a more sequential unloading of the current form then opening the next form. In some cases it appeared that Excel thought that some pages were open when they werent which caused all sorts of modal problems. I got around this by adding an unload command before I even loaded the new form just to ensure that Excel knew that the form was not open. This sequence (shown below) has proved the least prone to failure but it is not very attractive with the Worksheets exposed between Forms.
Teh last issue was that I tried to make a general macro that was callable from any Userform. I thought that the effect of choosing the current page again would simply be to 'refresh it'. However, it results in the form flickering on and off incessantly.
Has anyone encountered this before or have any suggestions.

Aye
John Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
Private Sub ComboBox1_Change()
 
    Select Case Me.ComboBox1.Text
        Case ComboBox1.List(0)
            Unload Me
            Unload Intro
            Load Intro
            Intro.Show
        Case ComboBox1.List(1)
            Unload Me
            Unload Data
            Load Data
            Data.Show
        Case ComboBox1.List(2)
            Unload Me
            Unload AV
            Load AV
            AV.Show
         Case ComboBox1.List(3)
            Unload Me
            Unload Quiz
            Load Quiz
            Quiz.Show
        Case ComboBox1.List(4)       ' the currenmt page
 '           Unload Me
 '           Unload Assess
 '           Load Assess
  '          Assess.Show
[+][-]05.20.2008 at 02:13AM PDT, ID: 21604472

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 05:29AM PDT, ID: 21605483

View this solution now by starting your 14-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Visual Basic Programming
Tags: Msoft, 2003, Excel
Sign Up Now!
Solution Provided By: fanpages
Participating Experts: 2
Solution Grade: B
 
 
[+][-]05.21.2008 at 02:16AM PDT, ID: 21613220

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 03:14AM PDT, ID: 21622411

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-43 / EE_QW_2_20070628