I can see already that the code will not go on to the next line after the
UF.Show line without a Private OKClick macro telling it to do so. What
should that macro say? Thanks for your help. Otto
"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
Up until now I have always used a UF in a structure of:
UF.Show
The UF OKClick macro calls a macro.
That macro:
Make selections
Builds an array or does something with the selection.
End macro
The UF OKClick macro unloads the UF.

Now I want to put the UF inside a loop with the following structu
Start the loop.
UF.Show (Have an OK button but no Private OKClick macro at all)
Make selections.
Build an array or do something with the selection.
Unload the UF
Exit Sub if conditions warrant
Modify the ranges and properties of the UF components (like a ListBox)
Loop

I just don't want to write all this code if my basic structure is flawed.
Is the basic structure flawed?
Will the code move on even though there is no Private OKClick macro?
Thank you for your help. Otto