Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way to move the focus around on a web form from VBA - Excluding "SendKeys {TAB}"???
Dennis |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you can get a reference to the root HTMLDocument object then you can use that to reach the appropriate child elements' focus() method
Eg: for a text input with Id or Name of "txtFocus" doc.getElementById("txtInput").focus or doc.getElementsByName("txtInput")(1).focus For plenty of examples on how to get a reference to the Document object, Google on "automate IE VB[A]" Tim "Dennis Tucker" wrote in message ... Is there any way to move the focus around on a web form from VBA - Excluding "SendKeys {TAB}"??? Dennis |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I do have this access. I think this is what I was looking for. I will try it out. Thank you so much.
Dennis "Tim Williams" wrote in message ... If you can get a reference to the root HTMLDocument object then you can use that to reach the appropriate child elements' focus() method Eg: for a text input with Id or Name of "txtFocus" doc.getElementById("txtInput").focus or doc.getElementsByName("txtInput")(1).focus For plenty of examples on how to get a reference to the Document object, Google on "automate IE VB[A]" Tim "Dennis Tucker" wrote in message ... Is there any way to move the focus around on a web form from VBA - Excluding "SendKeys {TAB}"??? Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
moving within forms | Excel Programming | |||
Forms and worksheet focus | Excel Programming | |||
TAB and focus moving from unprotected cell in protected sheet til dropdown. | Excel Programming | |||
NonModal Forms and Set Focus | Excel Programming | |||
Vying for the focus - Worksheet Vs Forms | Excel Programming |