modeless userforms

  • Thread starter Thread starter Don Cossitt
  • Start date Start date
D

Don Cossitt

Hello;

I notice in the properties dialog for userform there is an option for
"ShowModeless" = True/False. Additionally, it is advertised that in Excel
2000 one could use something like UserForm1.Show vbModeless. However, what
happens is this attribute locks my machine up and the only way out is to
CTRL-ALT-DEL | shutdown MSExcel. I went to Steve Bullen's site as suggest
by Tom Ogilvy to another poster, to get ideas, but have the same results.

I thought it was my machine here in the office as it has some age and is
slow. But I have the latest greatest 2.4ghz w/1gb ram at home and it does
the same thing. Both on Windows XP OS.

Any ideas?

TIA
doco
Any suggestions as
 
I am curious: why would one have a form (in conjunction with a spreadsheet),
any other way than modeless? It is modal that makes no sense.

I have a form with a MultiPage control with three tabs. The three tabs
represent three contexts: central tendency; trend; regression. Hopefully I
will have a fourth that will display a live chart. The purpose of the form
is to hover over a selected dataset on a worksheet, allowing the user to
select various ranges of data and do some analysis for the purpose of
further stratification against a given set of parameters. Being modeless
would be of great benefit here. However, when selecting the ShowModeless =
False or under UserForm_Activate()| Me.Modal vbModeless renders all controls
on the userform disabled. The only way out is to use CTL - ALT - DEL.

TIA
doco
 
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
 
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
 
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
 
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
 
Back
Top