Can Excel form have list box?

[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)?

 

[Bob Greenblatt]

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)?

Yes, but you¹ll have to build it. Look in help for data validation. It will
explain how to do this. Post back here if you are having further problems.

 

[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....?

 

[Bob Greenblatt]

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....?

Do you mean to use the list forms control to contain the list? That is also
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_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").

 

[Bob Greenblatt]

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").

Look at the forms toolbar. There is a list control that will probably do
what you want.