View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default How to minimize a userform!

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!