Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Code Enhancement?
Hello,
I have the following code that updates combo boxes located on a dashboard panel and are linked to a dynamic named range. The code is used to display dates in a friendly format vs a serial code. The combo boxes allow users to choose a "from" and "to" date for a dataset range. On an analysis tab, I have sumifs calculating from a raw dataset based upon the filters from the combo box on the dashboard. Every time I change the filter in my combo box, the data is calculating very slowly. I see the calculation msg in the lower right of the screen go from 0-100% about 4 times. I'm wondering if the sumifs are calculating each time the macro runs from private sub to end sub. Are there any ideas to make this process faster? I'm a little newer to vba. Any help appreciated; thanks! Private Sub ComboBox1_Change() Me.ComboBox1.Value = Format(Me.ComboBox1.Value, "mmm-yyyy") End Sub Private Sub UserForm_Initialize() Me.ComboBox1.RowSource = "dates_for_dv" Me.ComboBox1.Value = Format(Me.ComboBox1.Value, "mmm-yyyy") End Sub Private Sub ComboBox2_Change() Me.ComboBox2.Value = Format(Me.ComboBox2.Value, "mmm-yyyy") End Sub Private Sub UserForm2_Initialize() Me.ComboBox2.RowSource = "dates_for_dv" Me.ComboBox2.Value = Format(Me.ComboBox2.Value, "mmm-yyyy") End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup Enhancement | Excel Worksheet Functions | |||
DATEDIF formula enhancement | Excel Worksheet Functions | |||
Excel Grouping Enhancement | Excel Worksheet Functions | |||
Enhancement to Print Preview in Excel | Excel Discussion (Misc queries) | |||
Worksheet Protection - Enhancement | Excel Programming |