LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 67
Default UserForm show mode

Hi All!

I have a userform in excel workbook. The workbook itself should be minimized
while the userform is active, so I have added the following to the userform
initialize event:
Application.WindowState = xlMinimized.
I am wondering if it is possible to minimize also the userform for a while
(to be able to move to another excel workbook)and to activate it again
without loosing the data in the userform and without activating the workbook.

Many thanks for your help!

Eli
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get the filter mode to show the good row count? vera Excel Worksheet Functions 2 March 6th 07 03:24 PM
Image (object) offsets in Web show mode Anders Excel Worksheet Functions 0 November 13th 06 10:14 AM
Show value of variable on mouse-over in debug mode - bug? Chet Shannon[_4_] Excel Programming 0 January 9th 06 08:52 PM
form.show switches to debug mode rooch84 Excel Programming 1 September 6th 05 01:28 AM
Nudging controls in UserForm Design Mode Rick Brown Excel Programming 1 September 21st 04 11:47 PM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"