View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
Gary Gary is offline
external usenet poster
 
Posts: 273
Default VBA - Click mouse to change cursor to cross hair that spans th

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.