home hardware prices news articles forums photos user reviews
Go Back   Tech Support Forums - TechIMO.com > PC Hardware and Tech > Webmastering and Programming
Ask a Tech Support Question (free)!

Userform hiding issues

Reply
Get bargains at  »  Dealighted.com
 
Thread Tools Search this Thread
Currently Active Users: 1462
Discussions: 200,927, Posts: 2,379,137, Members: 246,294
Old February 6th, 2008, 05:17 PM   Digg it!   #1 (permalink)
Junior Member
 
Join Date: Feb 2008
Posts: 2
Userform hiding issues

In Excel I'm having issues hiding a Userform named "mission". My desire is to show it, delay 2 seconds or so, then get rid of it. I've tried this
Sub Picture182_Click()
mission.Show
Application.Wait Now + TimeValue("0:00:02")
Application.ScreenUpdating = True
mission.Hide
DoEvents
End Sub

The Userform shows up, but won't go away. hmmmm..
avatar46 is offline   Reply With Quote
Old February 6th, 2008, 05:28 PM     #2 (permalink)
Member
 
ChubTub's Avatar
 
Join Date: Nov 2002
Location: Twin Cities
Posts: 391
Can you close it rather than hide it?
ChubTub is offline   Reply With Quote
Old February 6th, 2008, 05:31 PM     #3 (permalink)
Junior Member
 
Join Date: Feb 2008
Posts: 2
Tried "Unload mission"
I've made a button and assigned macro
sub buttonclick()
unload mission
end sub

and it works great.
but not my original code. I'm scratching my head on this one.
avatar46 is offline   Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding the processes tab JBorland Applications and Operating Systems 0 September 15th, 2005 09:12 AM
Hiding FAD?? Undeadlord Distributed Computing 8 February 18th, 2005 05:32 PM
Hiding Web Address? micfau1091 Webmastering and Programming 4 December 27th, 2004 07:14 AM
Someone else is hiding underground... Toadman IMO Community 7 December 20th, 2003 09:53 PM
OuTpAtIeT's Hiding!!!!! NeoStarO1 IMO Community 33 January 27th, 2003 08:37 PM


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Most Active Discussions
Is It Just Me? (2867)
Is the PSU I received dead? (10)
windows vista security holes (9)
HIS HD5770 graphic card question (15)
Foreign voltage (10)
Print spooler problem (13)
Install XP pro and a Vista laptop ?.. (10)
Dept. of HS: NSA 'Helped' Develop V.. (15)
A good PSU? (10)
Ideal cheap graph card for PC-Gamin.. (15)
New Computer wont recognize XP disc (7)
EVGA 9800 gtx help with finding a g.. (8)
World's largest Monopoly Game using.. (331)
Modern Warfare 2: Who Bought It? (61)
Recent Discussions
Fire in DVD (2)
Regular Build (0)
Modern Warfare For the PC (33)
radeon x850xt platinum & shader 3 (3)
Have you switched yet? (84)
Install XP pro and a Vista laptop ?? (10)
Wireless Router+Cable Modems and Much.. (0)
Optical Audio A-B Switch (1)
windows vista security holes (9)
The NTDVM CPU has encountered an ille.. (24)
[F@H SPAM 11/16/09] ! 1/2 months to r.. (34)
Wireless speakers for PC? (11)
Print spooler problem (13)
Help getting around port 80 for camer.. (2)
Display shows 3x5 inch in middle of s.. (3)
monitor will not turn on at all, (1)
World's largest Monopoly Game using G.. (331)
Foreign voltage (10)
FiOS modem/router interfering with ne.. (7)
Browsers wont load websites (2)
Virus Doctor Popup? (1)
Dept. of HS: NSA 'Helped' Develop Vis.. (15)
EVGA 9800 gtx help with finding a goo.. (8)
Problem with speed step/turbo boost? (1)
Modern Warfare 2: Who Bought It? (61)


All times are GMT -4. The time now is 02:36 AM.
TechIMO Copyright 2009 All Enthusiast, Inc.



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28