Update Cells after DropDown Selection

Posted on 2012-08-23
Last Modified: 2012-08-27
Hi Experts,

Objective: to update cells (yellow) after selecting a product in the dropdown.

Situation: Currently, the file in attachment requires that I refresh the sheet with F9 in order to see the changes. Surely, there must be a way not to use F9...  

Method 1: (one step) update yellow cells immediately after selecting a product in the dropdown.

Method 2: (two steps) update yellow cells not before clicking on the Display Data button after selecting a product in the dropdown.

Why asking for 2 methods?  I need to know the differences in between the two methods (listed above) so I can learn from example.

My preferences go to Method 1 as it requires only one action from the user.
However, I would also want to know how to achieve objective with Method 2.

Thanks for your time and input.
Question by:fredericgilbert
    LVL 8

    Accepted Solution

    Change calculation to automatic:
    Private Sub Workbook_Open()
        Application.Calculation = xlCalculationAutomatic
    End Sub

    Open in new window

    LVL 8

    Expert Comment

    by:Elton Pascua
    It looks like you can't control the events in a form control so you can't run a code when the dropdown changes. You can, however, do something like the one below but the user would have to click somewhere in the sheet to force calculation.


    Open in new window


    Author Comment

    Thanks Techfanatic for the time you took to review my question.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now