How to set up a modeless userform so user actions can be performed

[Ianmacros]

I would like to run the code below to set up a pivot table, then wait to run the remaining code until the user sets up the pivot table fields (since these change from client to client). I had read that creating a modeless user form would be the way to go. However, on testing it seems that the code keeps running even though the userform dialog is activated.

Please Login or Register  to view this content.

[Ianmacros]

From some additional research, I see that with a modeless user form the code does not wait (I thought it did). However, with a modal form I am unable to interact with the workbook so that's not a good solution either. Is there a way where I can make the code wait AND interact with the workbook?

[Ianmacros]

I ended up separating the code into 2 macros. Then I added a user form with a command button to run the code. I added a show user form code (with vbModeless) to the end of the first macro. Then clicked the button to run the second part of the code.