Combo Box / Hard Coded List Of All, "Markets"

trip_to_tokyo

New Member
Joined
Dec 17, 2009
Messages
13
Continuing to work down page 225 of Pivot Table Data Crunching for MS EXCEL 2007.

Point number 2 on that page states:-

"Activate the Forms toolbar and place a combo box onto your spreadsheet"

Fine, I have done that.

Now it goes on to say:-

"3. Create a hard-coded list of all the markets that exist in your pivot table."

What the book fails to state is HOW to do this.

Can anybody assist here please?

Column E of my underlying data for the Pivot Table is called:-

Market

Thanks in advance for any replies.
 
How about typing out this list in cells on a worksheet?

I think that might be what is being suggested - but then again I've never actually read the book, or any book about how to use Excel.

PS Please don't say again that the book is wrong.:)
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top