Thanks all.

I guess I'll have to roll my own range selection process - with a modeless
form and forget using the RefEdit control.

doco


"Tom Ogilvy" wrote in message
...
Not that it is any comfort, but in the help for the refedit control, it
actually does say that.

from excel 2000 help for RefEdit

You cannot use a RefEdit control on a modeless user form. You can use the
ShowModal property to set a user form to modal.



--

Regards,

Tom Ogilvy



"Don Cossitt" wrote in message
...
So that's it! Yes I have at least two on each tab of the MultiPage
control.
That sucks big time!!

Thanks for the heads up.

doco

"Mark Bigelow" wrote in message
...
Does your modeless userform have a RefEdit control on it? If so,
that's
why. I recently learned, through this group, that you cannot show a
userform modelessly with a RefEdit control because it will freeze your
system. Don't ask me why.

If you don't have a RefEdit control, what controls do you have?
Perhaps
you could paste your code?

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!