Make Modaless form wait for 'OK' click

Hey all,

I have a form that I have to show Modaless (Due to needing other forms to be like this), but this particular one I would like to hold the macro until 'OK' is pressed. Is there anyway of doing this?

Thanks.

Have the macro show the form then end sub

Have rest of code attached or called from the OK button

You could send your macro into an endless DoEvents loop, checking to see if a certain Boolean variable had been set, and if so exit the loop. Then just use your form button to set that variable.

EDIT or do what he said ^^^^^^^^