View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default VBA - Click mouse to change cursor to cross hair that spans th

Gary,
No need to disable the browser as it's container (the frame) is disabled.
Did you replace the cross hair labels with frames ?
And ensure the browser's frame is furthest backward ?

NickHK

"gary" wrote in message
...
Nick,

I reread your last reply and you said I needed to disable the browser as
well as the Frame. How do I disable the browser ? I'm suspicious becaue

the
cross hairs in no way cover the frame right now.

Gary

"gary" wrote:

Nick,

I tried what you suggested (Browser inside Frame that is disabled) but

no
difference. The cross hairs do not cover the frame either. The user

might
want to get control of the browser which I could accomodate with a

button I
could add on the UserForm.

Gary

"NickHK" wrote:

Gary,
I'm no expert in this (or Excel for that matter..), but this now

sounds like
it has little to do Excel as such.
Whilst you can reparent IE to your userform, I see no way to respond

to
mouse movements (without sub-classing or something). Also, how do you

intend
to draw your cross hairs ?
I'm not clear on why you need to do this. You say "so the user can

more
accurately get values that are displayed along the borders".
So what do "get values" mean ?

NickHK

"gary" wrote in message
...
Nick,

The IE browser is completely separate from the User Form. The code

to
control the browser resides on the user form which is kicked off

from
excel
after the user has set several parameters. So besides needing to

put
cross
hairs on the IE browser, the cross hairs need to be responsive to

mouse
movements on the browser.