| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a pivot table be displayed on a user form?
Can a pivot table be displayed on a user form?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can a pivot table be displayed on a user form?
Hi
Assuming "display" means that you want to interact with it: Rightclick the Controls toolbox and choose "additional controls". You may see a "Microsoft Office Pivot Table" control, depending on your, and the user's, excel version. If display just means display, you may have to do some screen capture magic. PastePicture from http://www.oaltd.co.uk/Excel/Default.htm may be a good start. HTH. Best wishes Harald "Sandy" wrote in message ... Can a pivot table be displayed on a user form? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can a pivot table be displayed on a user form?
Thanks you, I have Office 2003 and do not have the control you referenced.
"Harald Staff" wrote: Hi Assuming "display" means that you want to interact with it: Rightclick the Controls toolbox and choose "additional controls". You may see a "Microsoft Office Pivot Table" control, depending on your, and the user's, excel version. If display just means display, you may have to do some screen capture magic. PastePicture from http://www.oaltd.co.uk/Excel/Default.htm may be a good start. HTH. Best wishes Harald "Sandy" wrote in message ... Can a pivot table be displayed on a user form? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can a pivot table be displayed on a user form?
In my version of xl2003 it has "Microsoft Pivot Table Version 11.0" in the
extra controls drop down list. "Sandy" wrote: Thanks you, I have Office 2003 and do not have the control you referenced. "Harald Staff" wrote: Hi Assuming "display" means that you want to interact with it: Rightclick the Controls toolbox and choose "additional controls". You may see a "Microsoft Office Pivot Table" control, depending on your, and the user's, excel version. If display just means display, you may have to do some screen capture magic. PastePicture from http://www.oaltd.co.uk/Excel/Default.htm may be a good start. HTH. Best wishes Harald "Sandy" wrote in message ... Can a pivot table be displayed on a user form? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Controlling how many rows of data are displayed in t | Excel Discussion (Misc queries) | |||
| worksheet cells displayed on a user form | Excel Programming | |||
| User form to change manual field filter in pivot table | Excel Discussion (Misc queries) | |||
| How do I get "multiple selections" displayed in Pivot Table Field | Setting up and Configuration of Excel | |||
| Pivot table displayed by day of the week | Excel Discussion (Misc queries) | |||
Hybrid Mode
