View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Check if form is open

Just for information,
note that doing

if uf1.visible

implicitely loads uf1 if it wasn't already loaded.

--
Regards,
Tom Ogilvy

"Sharad" wrote in message
...
I assume you mean a UserForm
If you want to know if an userform is actually shown or not then
you can use

' If uf1.Visible Then '

Sharad


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!