?
Solved

Update Cells after DropDown Selection

Posted on 2012-08-23
3
Medium Priority
?
305 Views
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.
dropDown.xlsm
0
Comment
Question by:fredericgilbert
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Elton Pascua earned 2000 total points
ID: 38327305
Change calculation to automatic:
Private Sub Workbook_Open()
    Application.Calculation = xlCalculationAutomatic
End Sub

Open in new window

0
 
LVL 8

Expert Comment

by:Elton Pascua
ID: 38327311
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.

ThisWorkbook.Worksheets("Summary").Range("calcRange").Calculate

Open in new window

0
 

Author Comment

by:fredericgilbert
ID: 38339122
Thanks Techfanatic for the time you took to review my question.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

862 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