Hi Rody,

That code was actually meant to subclass a WorkBook Window NOT a UserForm.
Furthermore,it doesn't actually trap the propper Message "WM_MOUSEMOVE" so
it is not the propper solution...was just a close attempt .

I am experimenting with some code at the moment but the Form keeps freezing
when it is subclassed.

I have been searching the Net as well as the most advanced Books on Excel
for some snippet code on how to Subclass Excel UserForms or Excel for that
matter but can't find anything at all.

Just imagine how much power & control one could get over our Excel Apps if
Subclassing was possible .

Any ideas anyone ?

Thanks.







"Rody Meulman" wrote:

Try http://tinyurl.com/e22fy




"RAFAAJ2000" schreef in bericht
...
Thanks Bob for the prompt reply.

The code you provided doesn't actually use SubClassing, it just uses a
timer
to periodically update the Form Styles . What I would like is to trap the
the
Windows Messages sent to the Form like the Mouse\Keyboard messages among
others.

So for example, this would allow me to left click the UserForm Title
Bar,trap this mouse event and display a standard MsgBox..... This is
something that can't be achieved by using the Form's native events.

Any more thoughts anyone ?

Thanks.

Jaafar.





"Bob Phillips" wrote:

I have uploaded an example for you to examine at
http://cjoint.com/data/hCpvjfeoGu.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RAFAAJ2000" wrote in message
...
Is it possible ?

I gave up trying to subclass the Excel App Window as it just seems to
be
impossible....But how about subclassing an Ecxel/VBA UserForm ?

Does anyone have a working example ? I am very curious to see one .

Thanks in advance.

Jaafar.