#1   Report Post  
Posted to microsoft.public.excel.misc
PaulW
 
Posts: n/a
Default Boxes in Forms

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
check boxes - copy MarkT Excel Discussion (Misc queries) 2 October 20th 05 04:33 PM
Problem Deleting Check Boxes created from Forms Toolbar Suzan Excel Discussion (Misc queries) 4 September 15th 05 06:30 PM
Check Boxes vknight Excel Discussion (Misc queries) 1 June 20th 05 11:13 AM
Excel 2002 Will Not Print Text Boxes Mark Excel Discussion (Misc queries) 3 April 16th 05 12:03 AM
Has anyone created forms in Excel with drop down boxes? mcdanik Excel Worksheet Functions 5 November 21st 04 04:04 PM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"