Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
check boxes - copy | Excel Discussion (Misc queries) | |||
Problem Deleting Check Boxes created from Forms Toolbar | Excel Discussion (Misc queries) | |||
Check Boxes | Excel Discussion (Misc queries) | |||
Excel 2002 Will Not Print Text Boxes | Excel Discussion (Misc queries) | |||
Has anyone created forms in Excel with drop down boxes? | Excel Worksheet Functions |