modeless userforms
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
"Jim Rech" wrote in message
...
I'm not a big fan of modeless userforms but I have used them without
hanging
Excel. Impossible to say why your code has this effect without seeing.
--
Jim Rech
Excel MVP
|