userform to automate pivot table creation

Hi all,

I am using Excel 2007 and I've created a macro which allows one to create a Pivot Table from a macro. One thing that I'm stuck on is instead of having the user of the macro hand enter the variables, I would like them to be able to use a list (or combo) box in a userform to select the variable/field, which will then populate the macro and create the pivot table when they click a button. The other thing that I can't figure out is how to get the macro to automatically create a new sheet rather than manually changed the worksheet (as you can see below I am at Sheet13. Thanks so much!

Please Login or Register  to view this content.

Does anyone have any suggestions to this question?? Thanks!