It may be a bit too much trouble for your purpose, but a good option is to
use a VB6 form.
They are much more like normal windows, so can minimize/maximize, have copy
and paste in
textboxes, have a listboxes that can scroll with the mouse wheel etc, and
all this without any API calls.
You can pick up a copy of VB6 Pro from EBay for about £200
RBS
"furbiuzzu" wrote in message
ups.com...
i'm not able to set 'minimize' & 'maximize' - window property on
userforms. Is it possible to do that on VB excel or not?
in particular i have an userform "working" with data inside a
worksheet.
if i change something inside userform i want to verify what's changed
in related worksheet too....
but there's no way to minimize the userform "activating" the sheet
selection.
so i have to close (userform.hide) the userform, to
"reactivate" the worksheet.
What to do ??
thanks in advance!