Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box / Hard Coded List
I have placed a Combo Box onto my spreadsheet.
How do I create a hard-coded list of all the markets (one of the fields / columns in my underlying Pivot Table Data). All I have on the screen in front of me at the moment is:- - my underlying Pivot Table data - the Pivot Table - a large downwards facing arrow (presumably the Combo Box). Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box / Hard Coded List
OK, got it sussed.
"trip_to_tokyo" wrote: I have placed a Combo Box onto my spreadsheet. How do I create a hard-coded list of all the markets (one of the fields / columns in my underlying Pivot Table Data). All I have on the screen in front of me at the moment is:- - my underlying Pivot Table data - the Pivot Table - a large downwards facing arrow (presumably the Combo Box). Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hard coded formula fix, VBA for column ordering | Excel Worksheet Functions | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
do the same thing to multiple hard coded cells | Excel Worksheet Functions | |||
Convert Hard-coded cell values to constants | Excel Discussion (Misc queries) | |||
References to open/hidden workbooks become hard-coded in formulas - 2003 | Excel Discussion (Misc queries) |