Hi,
I am trying achieve a consistent look and feel to my spreadsheet. I have a need to create a drop-down list on the same page that I have a Pivot Table. I would like my drop-down list to look exactly like the drop-down list on the Page Area of the Pivot Table (i.e. with the OK and Cancel buttons, the arrow embedded in the cell, the same grey matting around the edge, the fine dotted line connecting each item in the list etc...).
I've tried using Data | Validation | List, ActiveX ListBox and ComboBox, but all are different. How can this drop-down list be created?
Denny
I am trying achieve a consistent look and feel to my spreadsheet. I have a need to create a drop-down list on the same page that I have a Pivot Table. I would like my drop-down list to look exactly like the drop-down list on the Page Area of the Pivot Table (i.e. with the OK and Cancel buttons, the arrow embedded in the cell, the same grey matting around the edge, the fine dotted line connecting each item in the list etc...).
I've tried using Data | Validation | List, ActiveX ListBox and ComboBox, but all are different. How can this drop-down list be created?
Denny