Wait procedure until UserForm has been updated?

**mccrimmon** · 10-18-2011, 07:08 AM

Hello,

Im not sure if this is possible or not but would think it was.

I have a procedure that runs and does x, y and z in module 1.
It then loops through an array and ensures the data is in the array.

If the data is not in the array then it needs to be added, however, the user has to select the pricing method and source first.

To save manual error from an input box, I want the user to select from a UserForm combobox.

Please Login or Register  to view this content.

So the procedure would show the UserForm and the user would manually select the Pricing Source and Pricing Method from the drop downs.

I then want to continue my procedure in module 1? Is this possible?

Thanks

McCrimmon

**romperstomper** · 10-18-2011, 07:13 AM

That is what will happen by default - your code will pause while the form is shown and resume when the form is unloaded or hidden. You will need to return the values selected in the form, either using public variables or form properties. In the latter case, you will need to ensure that the form is only hidden, not unloaded, so that you can refer to the values on it.