Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Defining output range
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Defining output range
Resolved · Low Priority · Version 2003
Reply Fri 13 Mar 2009, 16:08Delegate Blair said...
Blair has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Defining output range
Can you tell me how to use a form to ask a user to input which variable they would like a pivot table to provide. That is, one user could ask how much saleperson A sold in 2005, with another asking how much salesperson B sold in 2007, with all being user input.
Thanks
For upcoming training course dates see: Pricing & availability
RE: defining output range
Hi Blair
To do this you would need to do the following:
1. Create the form with the required input methods (Text box or Combo box) to enter the fields to be displayed on the pivot table
2. In the program's module create Public variables to hold the information entered on the form
3. Write the Pivot table code using the variables in the PivotFields code lines
4. Place an OK buton on the form that when clicked passes the information entered to the variables and runs the Pivot Table code to create a Pivot table to reflect the requirements.
Hope this helps
Carlos
Mon 23 Mar 2009: Automatically marked as resolved.
|