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 ?
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 ?
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?
@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.
I think that the UserForm uses a date picker which requires Common Controls2, which MS stopped including some time ago.
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..
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.
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:
@ Fluff: I'm on Windows 10, but yes it was an upgrade installation from 7, which is probably why I got no error.Please Login or Register to view this content.
Definitely the delivery date (Leverdatum) relies on a date picker.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks