Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Rick Rothstein explained :
I already know about the event for checking when a user double clicks somewhere on a userform. I need to know if there is an event to check if a user double clicked the "active title bar" of the userform? (i.e the bar at the top of a userform). This fires the DblClick event since the title bar is an integral part of the userform. Clicking or Double-Clicking the title bar does not raise any UserForm events for me (XL2003). Rick Rothstein (MVP - Excel) You're right! I plead temporary insanity!<g I've been doing something to 'cause' the effect of rolling up a userform so what's underneath (behind) it can be viewed. To restore it I double-click just below the title bar. This, then, means I'm double-clicking the form itself. After looking at the code I see that I use its DblClick event so when I double-click the full size userform to 'roll it up' I do so on the userform surface. When rolled up it shows just enough blank space below the title bar that I can double-click the surface again to 'roll it back down'! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mouse double-click to select listbox item and run userform | Excel Programming | |||
Do not execute Double Click Event when UserForm is Showing | Excel Programming | |||
Double Click to run a sub then re-initializes userform?? Why??? | Excel Programming | |||
userform label double-click goes to click event | Excel Programming | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel |