View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default modeless userforms

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!