The easiest way to have a userform reappear in the same state as it was in
when last dismissed (in the same Excel session) is just to use Me.Hide
instead of Unload with your OK button.

--
Jim
"Michael Malinsky" wrote in message
oups.com...
|I have UserForm1 with MultiPage1. Page0 has three option buttons, One,
| Two, and Three. If One is selected, the next page shown is Page1 and
| so on. Once the process is complete, the code dumps various
| information into a worksheet (including the value of the option button
| selected).
|
| If the user runs the code again, instead of initially showing Page0,
| I'd like to initially show the page corresponding to the option button
| selected the first time around. Since I have the selection already in
| the worksheet, I figure I can use that to run a Select...Case, but I
| cannot seem to get the proper page of MultiPage1 to display as desired.
| Page0 always seems to pop up. I'm assuming that I would put this in a
| UserForm_Initialize procedure.
|
| Thanks,
| Mike.
|