R
R_poetic
I like the list manager and the ease of generating an input form for a list. Is there a way for a box in such a form to be a list box (you pick the text from a drop down list)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Greenblatt
Yes, but you¹ll have to build it. Look in help for data validation. It willI like the list manager and the ease of generating an input form for a list.
Is there a way for a box in such a form to be a list box (you pick the text
from a drop down list)?
explain how to do this. Post back here if you are having further problems.
R
R_poetic
Thanks! Per your advice, I have create a list where one of the fields (columns) accepts valid data only from a list that is populated with values elsewhere on the same sheet. I see the little arrows on the side of a selected cell in that field. That's most of what I wanted; the bit that perhaps isn't possible is to have the drop-down choices available in the "form" view of the list....?
B
Bob Greenblatt
Do you mean to use the list forms control to contain the list? That is alsoThanks! Per your advice, I have create a list where one of the fields
(columns) accepts valid data only from a list that is populated with values
elsewhere on the same sheet. I see the little arrows on the side of a selected
cell in that field. That's most of what I wanted; the bit that perhaps isn't
possible is to have the drop-down choices available in the "form" view of the
list....?
possible, but the cell will contain the index into the list and you¹ll have
to use a formula (like INDEX) to get the actual list value.
R
R_poetic
Yes, partly I was wondering if the control on the form for field "TYPE" (suppose that is the field in question) could offer the valid possibilities. (In a form that you might build in .NET or the like, the control would have a little arrow button on the side.) I understand the function INDEX() but how would it be used in this case (I don't understand "the cell will contain").
B
Bob Greenblatt
Look at the forms toolbar. There is a list control that will probably doYes, partly I was wondering if the control on the form for field "TYPE"
(suppose that is the field in question) could offer the valid possibilities.
(In a form that you might build in .NET or the like, the control would have a
little arrow button on the side.) I understand the function INDEX() but how
would it be used in this case (I don't understand "the cell will contain").
what you want.