+ Reply to Thread
Results 1 to 8 of 8

checkboxes selected looping while printing

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    Rotterdam Netherlands
    MS-Off Ver
    1906
    Posts
    6

    checkboxes selected looping while printing

    Can somebody have a look at my workbook ?

    Im holding my head against the wall for a few days..

    i dont know how to get the information from the checkboxes looped in one cell while printing ?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,522

    Re: checkboxes selected looping while printing

    I get this message: "Could not load an object because it is not available on this machine."
    And I don't see any checkboxes.
    Maybe explain what you want to do or make a regular workbook to attach.
    BTW, what is Office version 1906?

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: checkboxes selected looping while printing

    @jolivanes: Oddly I got no error. The checkboxes are in a userform.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: checkboxes selected looping while printing

    I think that the UserForm uses a date picker which requires Common Controls2, which MS stopped including some time ago.

  5. #5
    Registered User
    Join Date
    07-16-2019
    Location
    Rotterdam Netherlands
    MS-Off Ver
    1906
    Posts
    6

    Re

    fluff13.

    Its not about the date picker..

    its about the selection of checkboxes u see..

    if i select a2 changes.. i want if have multiple checkboxes selected this also prints the changes in the sheet..

    like a sort of looping..

    the information for the checkboxes come from sheet2

    there is a list and everything is linked..

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: checkboxes selected looping while printing

    You are using a datepicker that comes with Common controls 2, which stopped with either XP or Win 7 (I think). Therefore anybody who has not installed themselves will get an error.
    That is why Jolivanes got an error & Arkadi didn't. I also get the error so cannot help.

  7. #7
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: checkboxes selected looping while printing

    Because the Location in Palletkaart cell A3 is changed by a click event, it is not so elegant how I solved changing the names. For it to work, each checkbox must be numbered 1 less than the row where they are located in Adres. I tested for Heerenveen en Genk, but you will want to check it is ok for all checkboxes:

    Please Login or Register  to view this content.
    @ Fluff: I'm on Windows 10, but yes it was an upgrade installation from 7, which is probably why I got no error.

    Definitely the delivery date (Leverdatum) relies on a date picker.

  8. #8
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,522

    Re: checkboxes selected looping while printing

    Thanks Fluff13 and Arkadi.

    BTW, there are date pickers on the net that run on a userform platform and run on every computer without the need to install.
    Attached is just an example. There are many more.
    The file name will tell you where it originates from. Thanks to them.
    Attached Files Attached Files

+ 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. Looping through checkboxes - HELP NEEDED
    By mikebowman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2019, 07:27 AM
  2. [SOLVED] Looping through Form Controls checkboxes
    By tmallin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2015, 03:22 PM
  3. Looping though checkboxes and rows
    By venice.may1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2015, 01:16 PM
  4. Checkboxes keep printing, even though i've set them to not
    By arcanepsyche in forum Excel General
    Replies: 3
    Last Post: 02-26-2013, 04:41 AM
  5. Selective printing (via checkboxes)
    By DXP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2012, 06:11 AM
  6. Looping through a group of checkboxes
    By asdfasdf in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-12-2005, 10:05 PM
  7. [SOLVED] Looping Checkboxes on Worksheet
    By Robbyn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2005, 05:05 PM

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