Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that is embedded on a page that updates a Pivot
Table bases on a "State" selection. Is there a way to code a second ComboBox on the same page to execute the "Private Sub ComboBox01_Change()" programming. For example if Combox02_Change selects a metric such as "Sales or Quotes" once the person picks Sales it would then also run through the "Private Sub ComboBox01_Change()" procedure and pick the State again. Private Sub ComboBox01_Change() Dim sel_st sel_st = Evaluate("state2").Value Worksheets("Pivot1").PivotTables("PVTState").Pivot Fields("[DMA within State]").CurrentPageName _ = sel_st etc...... I guess what I am trying to do is find the code that is similar to the Application.Run language that I use to run a macro within a macro. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a combo box that is tied to another combo box? | Excel Worksheet Functions | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |