Default values in dependent combo box

[Former Member]

Hi gurus,

           
     I have 3 combo boxes - Region, Country and City.

Whenever I select the label 'ALL' in Region, I want the same label 'ALL' to appear in the combo boxes Region and City by default (ie) ALL should appear in all the 3 combo boxes whenever ALL is selected in the Region combo box.

A chart showing some data should be displayed whenever the above combination appears.

Can anyone please tell me how this can be achieved?

Thanks in advance,

Regards,

Aparajitha

[Former Member · Accepted solution]

Hi,

Map the selected items field in the properties section of the Combo Boxes to one (or more) cell(s) in the excel and write formula(e) to make the value(s) in those cells as "All". The formula can be built with IF function. (IF value from Region Combo box is ALL then make the cell value ALL.... etc..)

Let's say A1 contains the destination of Region Combo box, and A2 is the cell you are referring for selected items of other 2 combo boxes,

then : IF(A1="ALL","ALL")

Thanks,

Prasanna