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: 158
Default Determine if a userform is visible

Is this the only way to determine if a userform is
visible? :

if (Userform.Visible = true) then
' code here
end if

The problem with this code is that it seems to automatically
run the Userform_Initialize() routine. I'm wondering how
can I detect if a userform is visible without causing the
Userform_Initialize() routine to get invoked??

Thanks







 
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
Determine tje last visible row on the screen. SpeeD Excel Programming 6 January 14th 11 08:24 AM
A way to Determine visible cells on the page Mark Stephens Excel Programming 1 June 2nd 08 05:51 PM
Determine if a PivotField is visible? Whitney Yiu Excel Programming 7 December 22nd 07 06:33 AM
Determine upper visible corner of sheet John Michl Excel Programming 2 May 4th 06 04:14 PM
Programmatically determine if a control is .VISIBLE or not. Toby Erkson Excel Programming 2 April 16th 04 11:51 PM


All times are GMT +1. The time now is 06:18 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"