Double click message on userform....

[Robert Crandal]

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).

Anybody know if this is possible?

 

[GS]

It happens that Robert Crandal formulated :

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).

Anybody know if this is possible?

This fires the DblClick event since the title bar is an integral part
of the userform.

What are you trying to accomplish?

 

[Rick Rothstein]

I already know about the event for checking when a user

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)

 

[Robert Crandal]

I just thought it would be nice if I gave my users the ability to double
click the title bar of my userform to run a macro. I couldn't find any
events related to this.

Rick Rothstein also says, "Clicking or Double-Clicking the title bar
does not raise any UserForm events "

8(

 

[GS]

Rick Rothstein explained :

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'!