Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking combo boxes
Hello,
I have a spreadsheet that contains 3 combo boxes which drive pivot tables. Is there a way to syncronize all 3 pulldowns when the value of one changes. The intent is to have all 3 pivot tables (vendors) match upon a change in any of the pulldown boxes. Any help is appreciated. Thank You, Extreem |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking combo boxes
If you are going to always have the same value in each combobox then why
not drive all three pivottables off a single combobox? Anyway, assuming the comboboxes are from the Controls Toolbox and are on the same sheet then: Private Sub ComboBox1_Change() On Error GoTo ErrorHandler Application.EnableEvents = False Me.ComboBox2.Value = Me.ComboBox1.Value Me.ComboBox3.Value = Me.ComboBox1.Value ErrorHandler: Application.EnableEvents = True End Sub Private Sub ComboBox2_Change() On Error GoTo ErrorHandler Application.EnableEvents = False Me.ComboBox1.Value = Me.ComboBox2.Value Me.ComboBox3.Value = Me.ComboBox2.Value ErrorHandler: Application.EnableEvents = True End Sub Private Sub ComboBox3_Change() On Error GoTo ErrorHandler Application.EnableEvents = False Me.ComboBox1.Value = Me.ComboBox3.Value Me.ComboBox2.Value = Me.ComboBox3.Value ErrorHandler: Application.EnableEvents = True End Sub Hope this helps Rowan Extreem wrote: Hello, I have a spreadsheet that contains 3 combo boxes which drive pivot tables. Is there a way to syncronize all 3 pulldowns when the value of one changes. The intent is to have all 3 pivot tables (vendors) match upon a change in any of the pulldown boxes. Any help is appreciated. Thank You, Extreem |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Combo Boxes (Please Help) | Excel Worksheet Functions | |||
Linking Combo Boxes | Excel Programming | |||
Linking multiple combo boxes | Excel Programming | |||
Linking Combo Boxes | Excel Programming | |||
excel 97: linking 2 combo boxes | Excel Programming |