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.

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.

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.

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.

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.

check out SetWindowHook or SetWindowHookEx.

those allow you to monitor a subset of all messages
and you dont need to "passthru" the original message.

best bet is WH_MOUSE or WH_CBT


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


RAFAAJ2000 wrote :

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.