Excel 2007 ActiveX ComboBox question

[aha123]

I put the same ComboBox lists in two Tabs. When a user selects item X from the list in tab A, the list in tab B will get updated to have item X selected. This update is done via a VBA sub. I want to know if there is a non-VBA/macro way to do this.

[Winon]

Hello aha123,

What do you mean with, "Tab"? Are you perhaps referring to a Cell with a Data Validation Drop Down List?

[watersev]

hi aha123, do you need sort of that?

The first combo is linked to a cell '1'!C3 hidden by combo1, the combo2 is also linked to the same cell '1'!C3. Though it is Excel 2003 sample, it should be the same for Excel 2007.

[Kyle123]

You can also do this with froms comboboxes rather than ActiveX ones

[aha123]

@Winon, A Tab refers to a Sheet.
@Kyle12m ActiveX controls look better, right?

@watersev , your answer solves my problem. Thanks!

Here is an additional question:

I have two more tabs(Tab C & D) which are hidden. Tab C stores the data and Tab D contains a pivot table based on the data.

The pivot table has the same selection list as the ones in Tab A and Tab B. When the list selection is changed in Tab A/B, I want the pivot table selection gets updated too. Currently this is done via a VBA sub too. Is there any non-VBA way to accomplish this?

[watersev]

I suppose VB will be the only option

[Winon]

Hello aha123,

Re:

A Tab refers to a Sheet

Amongst other definitions for a "Tab", yes, I agree, it could refer to a Sheet, or also a Cell, or other instances as well!

Glad to see your problem is in the good hands of the other respondents.

[Kyle123]

@aha123 aesthetics are down to you, I prefer the look of dropdowns, additionally ActiveX controls on sheets can have a bad habit of not behaving themselves

To change a pivot table, have a look at the attached, I've included both options (dropdown and combobox)