+ Reply to Thread
Results 1 to 6 of 6

Rookie VBA question - How to tick TWO checkboxes on a webpage?

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Rookie VBA question - How to tick TWO checkboxes on a webpage?

    Hello!

    Im a rookie VBA user!
    I have written a code so that Excel starts IE and goes to a webpage. And on the webpage I need to tick two checkboxes before I click the SEARCHbutton on the webpage.

    The problem is that when I have ticked the first box, and then are going to tick the second box....the first one becomes de-selected. WHY?! I want them both ticked.

    The code:

    IE.document.getElementById("rooms1").Click
    IE.document.getElementById("rooms2").Click


    But, again, when rooms2 is clicked, rooms1 becomes deselected.

    What can I write? =(

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Rookie VBA question - How to tick TWO checkboxes on a webpage?

    Can you post the URL?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    04-17-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Rookie VBA question - How to tick TWO checkboxes on a webpage?

    http://www.booli.se/solna/35/ and then click on the button next to the searchfield "Förfina" . Then you will see alot of checkboxes, and Im trying to write a code which will tick the boxes to the right , under the label "Rum" (in english: rooms)

    Thanks for your time!=)

  4. #4
    Registered User
    Join Date
    04-17-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Rookie VBA question - How to tick TWO checkboxes on a webpage?

    Anyone know how to do it? =)

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    I tried the URL you posted but it didn't seem to work.

    I was able to get the main page of the site up.

    I'll try the URL again but it might help if you posted details of how to navigate from the main page to the one you are interested in.

  6. #6
    Registered User
    Join Date
    04-17-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Rookie VBA question - How to tick TWO checkboxes on a webpage?

    Ah okey!


    www.booli.se is the main page. Type in a searchword in the box, try "Stockholm" and then click the big button to the right. This should take you to a new page where all the search results is.

    Now you gonna push a button so you can see the chechboxes. The button you need to click is "Förfina" and is just next to the search field. And when you have clicked the button a lot of checkboxes will appear below.

    Im trying to tick the checkboxes which are to the right, under the label "Rum". I want to tick "1" and "2". But then I write VBA code it only selects one.


    I hope I wrote everything correct. Tell me, can you navigate to the checkboxes?
    Best regards!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rookie VBA question - Trouble entering excel data in to a searchbox on a webpage
    By andba731 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2014, 08:52 PM
  2. Excel 2007 : Interactive webpage with checkboxes
    By mefaraway in forum Excel General
    Replies: 0
    Last Post: 04-12-2012, 05:47 PM
  3. Multiple checkboxes to tick 1 checkbox
    By tUyET dEn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2009, 04:07 AM
  4. Another Rookie Question
    By Trishay321 in forum Access Tables & Databases
    Replies: 1
    Last Post: 01-28-2009, 07:20 AM
  5. A code question from a rookie
    By SuitedAces in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2006, 02:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1