VBA - Click mouse to change cursor to cross hair that spans th
Nick,
Yes yes !! The cross hairs now move on top of the browser !! One last (I
hope) question. How do I control the scroll bar positions in WebBrowseer1
from my vba program. I used to control the IE browser object with
ie.document.parentWindow.Scroll horiz, vert
Thanks for your help,
Gary
"NickHK" wrote:
gary,
Sorry, forgot I had changed the 2 x labels to 2 x frames.
Also, make sure the frame containing the browser is behind the 2 frames;
right-click on the frame's border and "Send Backward".
"gary" wrote in message
...
Nick,
Yes, I even added "Frame1.enabled = false" to no avail. The cross hairs
go behind the frame.
Any ideas ?
"NickHK" wrote:
Gary,
That works for me.
Sure you have Frame1.Enabled=False ?
You can have a button to toggle the .Enabled state of the frame.
NickHK
"gary" wrote in message
...
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.
Gay
"NickHK" wrote:
Gary,
But you are attempting to draw cross hairs on IE that is
completely
separated from your userform and Excel ?
Or you do have a web browser control on your userform ?
NickHK
|