P
PaulW
Making a list box, which can allow multiple answers, for the cell link box
what am I supposed to pick?
If I pick a single cell it has 0 in there, regardless of what I pick on the
list... or how many...
If I pick an array I get 0 in the first box exactly like before...
Also, for another part of the spreadsheet I plan on using Check boxes for a
user to change what the form does. Is it possible to have these Check boxes
there or not depending on how long a list is? It'd be a bit silly if one day
there are 15 options, with only 10 of them with Check Boxes, and the next day
5 options with the same 10 Boxes...
Thirdly, like I said, the number of options available change all the time,
this is usually a list of Status Codes, Employee Login Codes, etc and
depending on different variables this can be constantly changing. I usually
use a list in the Validation option to prevent mispelling and to provide
accurate results, but what i've found with it and with all the list boxes and
such i've tried, is that I end up with half the list as "blank" options I
need to allow for the maximum number of possible codes. Is there anyway of
changing this?
Cheers
what am I supposed to pick?
If I pick a single cell it has 0 in there, regardless of what I pick on the
list... or how many...
If I pick an array I get 0 in the first box exactly like before...
Also, for another part of the spreadsheet I plan on using Check boxes for a
user to change what the form does. Is it possible to have these Check boxes
there or not depending on how long a list is? It'd be a bit silly if one day
there are 15 options, with only 10 of them with Check Boxes, and the next day
5 options with the same 10 Boxes...
Thirdly, like I said, the number of options available change all the time,
this is usually a list of Status Codes, Employee Login Codes, etc and
depending on different variables this can be constantly changing. I usually
use a list in the Validation option to prevent mispelling and to provide
accurate results, but what i've found with it and with all the list boxes and
such i've tried, is that I end up with half the list as "blank" options I
need to allow for the maximum number of possible codes. Is there anyway of
changing this?
Cheers