working with .Document.getElementById() and variables in vba
up vote
0
down vote
favorite
I am trying to select the value from a dropdown box using vba, the code block for the dropdown box is as follows
<input type="text" id="form_autocomplete_input-1542902425322" list="form_autocomplete_suggestions-1542902425322" placeholder="Search keyword or select filter" role="combobox" aria-expanded="false" autocomplete="off" autocorrect="off" autocapitalize="off" aria-autocomplete="list" aria-owns="form_autocomplete_suggestions-1542902425322 form_autocomplete_selection-1542902425322">
If the value of form_autocomplete_suggestions-1542902425322 was static I would use .Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student" however this seems to be a randomly generated numerical value.
I have had a look and it seems I cannot simply add a wildcard in such as .Document.getElementById("form_autocomplete_suggestions-*").Value = "Role: Student"
And as its randomly generated and such a long number it cannot loop through an array of values. so I am unsure on how to solve this issue.
excel vba excel-vba
asked Nov 22 at 16:24
Aaran
33
add a comment |
up vote
0
down vote
favorite
I am trying to select the value from a dropdown box using vba, the code block for the dropdown box is as follows
<input type="text" id="form_autocomplete_input-1542902425322" list="form_autocomplete_suggestions-1542902425322" placeholder="Search keyword or select filter" role="combobox" aria-expanded="false" autocomplete="off" autocorrect="off" autocapitalize="off" aria-autocomplete="list" aria-owns="form_autocomplete_suggestions-1542902425322 form_autocomplete_selection-1542902425322">
If the value of form_autocomplete_suggestions-1542902425322 was static I would use .Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student" however this seems to be a randomly generated numerical value.
I have had a look and it seems I cannot simply add a wildcard in such as .Document.getElementById("form_autocomplete_suggestions-*").Value = "Role: Student"
And as its randomly generated and such a long number it cannot loop through an array of values. so I am unsure on how to solve this issue.
excel vba excel-vba
asked Nov 22 at 16:24
Aaran
33
So how many text boxes will there be on the form? You dont have to loop through the array of numbers, you can look at the options on offer beginning with.getElementsetc, to get them to a collection and loop those if neccessary. Can you explain a little more in numbers of objects, or paste a screen shot of the page.?
– Nathan_Sav
Nov 22 at 16:29
Hi, not sure what you mean by form? the problem is that the value of the dropdown box changes !image So I cannot use.Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student"as the value of 1542902425322 has now changed to something else.
– Aaran
Nov 22 at 16:57
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am trying to select the value from a dropdown box using vba, the code block for the dropdown box is as follows
<input type="text" id="form_autocomplete_input-1542902425322" list="form_autocomplete_suggestions-1542902425322" placeholder="Search keyword or select filter" role="combobox" aria-expanded="false" autocomplete="off" autocorrect="off" autocapitalize="off" aria-autocomplete="list" aria-owns="form_autocomplete_suggestions-1542902425322 form_autocomplete_selection-1542902425322">
If the value of form_autocomplete_suggestions-1542902425322 was static I would use .Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student" however this seems to be a randomly generated numerical value.
I have had a look and it seems I cannot simply add a wildcard in such as .Document.getElementById("form_autocomplete_suggestions-*").Value = "Role: Student"
And as its randomly generated and such a long number it cannot loop through an array of values. so I am unsure on how to solve this issue.
excel vba excel-vba
asked Nov 22 at 16:24
Aaran
33
I am trying to select the value from a dropdown box using vba, the code block for the dropdown box is as follows
<input type="text" id="form_autocomplete_input-1542902425322" list="form_autocomplete_suggestions-1542902425322" placeholder="Search keyword or select filter" role="combobox" aria-expanded="false" autocomplete="off" autocorrect="off" autocapitalize="off" aria-autocomplete="list" aria-owns="form_autocomplete_suggestions-1542902425322 form_autocomplete_selection-1542902425322">
If the value of form_autocomplete_suggestions-1542902425322 was static I would use .Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student" however this seems to be a randomly generated numerical value.
I have had a look and it seems I cannot simply add a wildcard in such as .Document.getElementById("form_autocomplete_suggestions-*").Value = "Role: Student"
And as its randomly generated and such a long number it cannot loop through an array of values. so I am unsure on how to solve this issue.
excel vba excel-vba
excel vba excel-vba
asked Nov 22 at 16:24
Aaran
33
asked Nov 22 at 16:24
Aaran
33
asked Nov 22 at 16:24
Aaran
33
asked Nov 22 at 16:24
Aaran
33
asked Nov 22 at 16:24
Aaran
33
33
So how many text boxes will there be on the form? You dont have to loop through the array of numbers, you can look at the options on offer beginning with.getElementsetc, to get them to a collection and loop those if neccessary. Can you explain a little more in numbers of objects, or paste a screen shot of the page.?
– Nathan_Sav
Nov 22 at 16:29
Hi, not sure what you mean by form? the problem is that the value of the dropdown box changes !image So I cannot use.Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student"as the value of 1542902425322 has now changed to something else.
– Aaran
Nov 22 at 16:57
add a comment |
So how many text boxes will there be on the form? You dont have to loop through the array of numbers, you can look at the options on offer beginning with.getElementsetc, to get them to a collection and loop those if neccessary. Can you explain a little more in numbers of objects, or paste a screen shot of the page.?
– Nathan_Sav
Nov 22 at 16:29
Hi, not sure what you mean by form? the problem is that the value of the dropdown box changes !image So I cannot use.Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student"as the value of 1542902425322 has now changed to something else.
– Aaran
Nov 22 at 16:57
So how many text boxes will there be on the form? You dont have to loop through the array of numbers, you can look at the options on offer beginning with
.getElements etc, to get them to a collection and loop those if neccessary. Can you explain a little more in numbers of objects, or paste a screen shot of the page.?– Nathan_Sav
Nov 22 at 16:29
So how many text boxes will there be on the form? You dont have to loop through the array of numbers, you can look at the options on offer beginning with
.getElements etc, to get them to a collection and loop those if neccessary. Can you explain a little more in numbers of objects, or paste a screen shot of the page.?– Nathan_Sav
Nov 22 at 16:29
Hi, not sure what you mean by form? the problem is that the value of the dropdown box changes !image So I cannot use
.Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student" as the value of 1542902425322 has now changed to something else.– Aaran
Nov 22 at 16:57
Hi, not sure what you mean by form? the problem is that the value of the dropdown box changes !image So I cannot use
.Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student" as the value of 1542902425322 has now changed to something else.– Aaran
Nov 22 at 16:57
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
You can use css attribute equals value selector syntax with the ^ modifier to say starts with a certain substring. You could also use * instead, which means contains.
[id^='form_autocomplete_input-']
VBA:
ie.document.querySelector("[id^='form_autocomplete_input-']")
You might also use:
[placeholder='Search keyword or select filter']
Which would be:
ie.document.querySelector("[placeholder='Search keyword or select filter']")
As you indicate this needs to be selected you may need:
ie.document.querySelector("[id^='form_autocomplete_input-']").Selected = True
Reference:
- CSS attribute selectors
answered Nov 22 at 16:53
QHarr
28.4k81839
Did you try this?
– QHarr
Nov 23 at 19:34
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
You can use css attribute equals value selector syntax with the ^ modifier to say starts with a certain substring. You could also use * instead, which means contains.
[id^='form_autocomplete_input-']
VBA:
ie.document.querySelector("[id^='form_autocomplete_input-']")
You might also use:
[placeholder='Search keyword or select filter']
Which would be:
ie.document.querySelector("[placeholder='Search keyword or select filter']")
As you indicate this needs to be selected you may need:
ie.document.querySelector("[id^='form_autocomplete_input-']").Selected = True
Reference:
- CSS attribute selectors
answered Nov 22 at 16:53
QHarr
28.4k81839
Did you try this?
– QHarr
Nov 23 at 19:34
add a comment |
up vote
1
down vote
You can use css attribute equals value selector syntax with the ^ modifier to say starts with a certain substring. You could also use * instead, which means contains.
[id^='form_autocomplete_input-']
VBA:
ie.document.querySelector("[id^='form_autocomplete_input-']")
You might also use:
[placeholder='Search keyword or select filter']
Which would be:
ie.document.querySelector("[placeholder='Search keyword or select filter']")
As you indicate this needs to be selected you may need:
ie.document.querySelector("[id^='form_autocomplete_input-']").Selected = True
Reference:
- CSS attribute selectors
answered Nov 22 at 16:53
QHarr
28.4k81839
Did you try this?
– QHarr
Nov 23 at 19:34
add a comment |
up vote
1
down vote
up vote
1
down vote
You can use css attribute equals value selector syntax with the ^ modifier to say starts with a certain substring. You could also use * instead, which means contains.
[id^='form_autocomplete_input-']
VBA:
ie.document.querySelector("[id^='form_autocomplete_input-']")
You might also use:
[placeholder='Search keyword or select filter']
Which would be:
ie.document.querySelector("[placeholder='Search keyword or select filter']")
As you indicate this needs to be selected you may need:
ie.document.querySelector("[id^='form_autocomplete_input-']").Selected = True
Reference:
- CSS attribute selectors
answered Nov 22 at 16:53
QHarr
28.4k81839
You can use css attribute equals value selector syntax with the ^ modifier to say starts with a certain substring. You could also use * instead, which means contains.
[id^='form_autocomplete_input-']
VBA:
ie.document.querySelector("[id^='form_autocomplete_input-']")
You might also use:
[placeholder='Search keyword or select filter']
Which would be:
ie.document.querySelector("[placeholder='Search keyword or select filter']")
As you indicate this needs to be selected you may need:
ie.document.querySelector("[id^='form_autocomplete_input-']").Selected = True
Reference:
- CSS attribute selectors
answered Nov 22 at 16:53
QHarr
28.4k81839
edited Nov 22 at 16:59
answered Nov 22 at 16:53
QHarr
28.4k81839
answered Nov 22 at 16:53
QHarr
28.4k81839
answered Nov 22 at 16:53
QHarr
28.4k81839
28.4k81839
Did you try this?
– QHarr
Nov 23 at 19:34
add a comment |
Did you try this?
– QHarr
Nov 23 at 19:34
Did you try this?
– QHarr
Nov 23 at 19:34
Did you try this?
– QHarr
Nov 23 at 19:34
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434972%2fworking-with-document-getelementbyid-and-variables-in-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
So how many text boxes will there be on the form? You dont have to loop through the array of numbers, you can look at the options on offer beginning with
.getElementsetc, to get them to a collection and loop those if neccessary. Can you explain a little more in numbers of objects, or paste a screen shot of the page.?– Nathan_Sav
Nov 22 at 16:29
Hi, not sure what you mean by form? the problem is that the value of the dropdown box changes !image So I cannot use
.Document.getElementById("form_autocomplete_suggestions-1542902425322").Value = "Role: Student"as the value of 1542902425322 has now changed to something else.– Aaran
Nov 22 at 16:57