VBA to checkbox on IE

Question

I'm unable to tick/click checkbox on IE (through VBA) and it seems I have tried a lot of methods already. Can you please advise?

FYI Elements:

<div class="bordered_table" id="mig-to-prod"> <div class="edl_checkbox floatleft"> <input type="hidden" name="_selectAllConfigs" value="visible" /> <label class="edl_chb"> <input type="checkbox" name="selectAllConfigs" onclick="changeDropDown(this.form);"> <span></span>

The checkbox is edl_chb

I have tried:

Html.querySelector("a[title=edl_chb]").Click Html.querySelector("a[title='edl_chb']").Click Html.querySelector("a[title='edl_chb']")(0).Click Html.querySelector("a[title='edl_chb']")(1).Click

I have also tried to getelemtsbyclassname

Am afraid I can't, it's a corporate website (of some firm) that only works after security login.Sorry — Alien_Explorer
– Alien_Explorer, Commented Nov 16, 2018 at 10:00
Are you getting any error messages? Are you selecting the correct element but simply no check appears? — QHarr
– QHarr, Commented Nov 16, 2018 at 10:04

QHarr · Accepted Answer · 2018-11-16 10:20:02Z

1

Be sure to allow enough time for page to load. This includes having the following after the .Navigate2 line.

While ie.Busy Or ie.readyState < 4: DoEvents: Wend

For other approaches see here.

You could try an attribute = value combination of

ie.document.querySelector("[type=checkbox][name=selectAllConfigs]").click

Or

ie.document.querySelector("[type=checkbox][name=selectAllConfigs]").FireEvent "onclick"

edited Nov 16, 2018 at 10:20

answered Nov 16, 2018 at 10:02

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Alien_Explorer Over a year ago

In the first case I have received an error 424 Object Required, in the second case the same.

QHarr Over a year ago

Are you 1) Leaving a sufficient wait for page load before this? Can you show the rest of your code? 2) Have you checked the element is not inside a parent frame/iframe? Some further info here

Alien_Explorer Over a year ago

Hi, you were right, I forgot about allowing the page to load in! Do While IEx.Busy Application.Wait DateAdd("s", 1, Now) Loop, solved everything and the first line (solution) worked perfectly! Thanks a lot QHarr

Collectives™ on Stack Overflow

VBA to checkbox on IE

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related