+ Reply to Thread
Results 1 to 8 of 8

Tick a checkbox online from Excel VBA

  1. #1
    Registered User
    Join Date
    03-03-2020
    Location
    London, England
    MS-Off Ver
    16
    Posts
    3

    Tick a checkbox online from Excel VBA

    Hi,

    I have a website with different different checkboxes, all with their own ID.

    I also have a list in Excel, each with their corresponding ID of the checkbox that is currently online.

    Example:
    Text 1 | Checkbox ID 1
    Text 2 | Checkbox ID 2
    Text 3 | Checkbox ID 3

    What I would like (if someone can kindly help me), is to be able to run a macro in Excel to tick any of the boxes on the page that appear on my list in Excel, and ignore the items in the list that are not on that page. Once all of the boxes that are on both the Excel file and the web page are ticked, just stop the macro there and leave the web page open. (ie, Text 2 might not be on the page, so just tick the two checkboxes that correspond with Text 1 and Text 3, then stop the macro).

    The next part of this, is the list continues on a second page on the website. I would like to be able to run this code on whichever page I choose.

    Can anyone help me?

    I hope I have explained this properly!

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    03-03-2020
    Location
    London, England
    MS-Off Ver
    16
    Posts
    3

    Re: Tick a checkbox online from Excel VBA

    Hello,

    Thank you for your reply.

    Please see attached how the xlsx file will look. It is a very simple Excel sheet, the complicated part is the VBA which I do not know how/if it will work.

    Kind Regards
    Attached Files Attached Files

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Tick a checkbox online from Excel VBA

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (I will add it for you as you are new here.Please read forum rules which you seem to have missed

    https://www.excelguru.ca/forums/show...from-Excel-VBA

  4. #4
    Registered User
    Join Date
    03-03-2020
    Location
    London, England
    MS-Off Ver
    16
    Posts
    3

    Re: Tick a checkbox online from Excel VBA

    Hello,

    Apologies for that, I did not read the forum rules before posting. I did not receive a reply for over 5 hours, so assumed that nobody on this forum had a solution for me. Hence me posting on another forum to look for an answer as well.

    Regards,

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Tick a checkbox online from Excel VBA


  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Tick a checkbox online from Excel VBA

    Administrative Note:

    Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so.
    It can take some time before you get an answer, but if it is urgent you can always contact our Commercial Services

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Tick a checkbox online from Excel VBA

    Quote Originally Posted by torachan View Post
    will involve a lot of guess work
    Do not post links as you answer.

  8. #8
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Tick a checkbox online from Excel VBA

    Why not ?

+ 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. 1 checkbox tick from 3
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2014, 07:12 AM
  2. Tick checkbox and add a date
    By -emma- in forum Excel General
    Replies: 8
    Last Post: 07-03-2012, 08:04 PM
  3. Excel 2007 : Checkbox auto tick on value
    By Midri in forum Excel General
    Replies: 4
    Last Post: 01-28-2011, 09:15 AM
  4. tick checkbox to trigger another checkbox
    By aviflux in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-28-2008, 07:59 AM
  5. Copy tick from checkbox to another checkbox
    By AngieE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2007, 07:45 AM
  6. [SOLVED] Checkbox to be marked with a cross rather than a tick
    By Den in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-22-2006, 06:10 AM
  7. I would like to have a cross in my checkbox rather than a tick
    By Den in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2005, 02:50 AM

Tags for this Thread

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