How to keep a Userform available while the user interacts with a spreadsheet
 

In Excel 97, userforms are only modal. Stephen Bullen documents a way to
make them modeless, but it is a "trick" so I am not sure you want to use it
in an application. (in xl2000, the userform has an option to be modeless)

http://www.bmsltd.co.uk/Excel/Default.htm


If you just want the user to select a range, you can use a refedit control.

--
Regards,
Tom Ogilvy


TBA wrote in message
...
Excel 97
Windows 2k Pro

I have a Userform that loads and is shown when a button is pressed on a
custom toolbar. I'd like to be able to minimize the form or in some way
"keep it on top" while the user interacts with the spreadsheet.
Unfortunately I believe there is something fundamentally wrong with my
approach to this little program. That or I've chosen the wrong object to
house my user options. Is there some way to keep the form available and
still allow the user to interact with the spreadsheet? Or is it back to
the
drawing board?. As usual, all suggestions and criticisms welcome.

-gk-

How to keep a Userform available while the user interacts with a spreadsheet
 

Thanks Tom. I did download Stephen's sample workbook from an earlier
question I asked. Guess I better read up on Modality and see about
upgrading.

-gk-

"Tom Ogilvy" wrote in message
...
In Excel 97, userforms are only modal. Stephen Bullen documents a way to
make them modeless, but it is a "trick" so I am not sure you want to use
it
in an application. (in xl2000, the userform has an option to be
modeless)

http://www.bmsltd.co.uk/Excel/Default.htm


If you just want the user to select a range, you can use a refedit
control.

--
Regards,
Tom Ogilvy


TBA wrote in message
...
Excel 97
Windows 2k Pro

I have a Userform that loads and is shown when a button is pressed on a
custom toolbar. I'd like to be able to minimize the form or in some way
"keep it on top" while the user interacts with the spreadsheet.
Unfortunately I believe there is something fundamentally wrong with my
approach to this little program. That or I've chosen the wrong object
to
house my user options. Is there some way to keep the form available and
still allow the user to interact with the spreadsheet? Or is it back to
the
drawing board?. As usual, all suggestions and criticisms welcome.

-gk-