ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pesky Ckeckboxes ! (https://www.excelbanter.com/excel-programming/276610-pesky-ckeckboxes.html)

neil

Pesky Ckeckboxes !
 
I have some data in a data table, left most column is an
id column, I have a form with a texbox, a button, and 10
checkboxes in a frame, (checkbox1 to checkbox10),
I want to be able to enter an id in the textbox on the
form then use this to lookup the 10 values for the
checkboxes, I have set up an array that will hold the 10
values, (0 or 1), I want to have a loop that matches the
10 values in the array to the 10 checkboxes, so that they
show as ticked or unticked if there is a 1 or a 0 in the
array.... I have looked at it every way I can but im not
getting very far, I could always write a line of code for
each checkbox, but that would be the get it done
mentality rather than the do it properly mentality...

Any help much appreciated !!!


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com