I believe from the Forms Toolbar. I am using Excel 2007, in the Developer
ribbon -> Insert (Here I have two categories to choose from "Form Controls"
and "ActiveX Controls") -> I inserted a combo box from the "Form Controls"
category. Is that more helpful?
My worksheet is an enrollment form. It allows the user who is filling out
the enrollment form to select that they are either representing an individual
school or a district that includes more than one school. If the user is
representing an individual school, then I want them to see only one combo box
where they will choose if they are a school that is one of three options -
Pre-K to K, Grades 1-8, or Grades 9-12. However, if the representative
filling in the form is filling it out for a district, then I allow them space
to fill in information on 10 different schools. So, in this case I would
need a combo box for each of the 10 schools.
Another way to think about it that may be helpful is that in my worksheet,
rows 45 - 80 include all of the cells I want filled in if it is an individual
school, and in these rows I have placed my combo box for this one school.
Rows 81 - 200 include all of the cells that need to be filled in for the 10
schools that are within the school district, and in these rows I have placed
10 different combo boxes, one for each school.
So, if the user filling in my enrollment form selects that they are
representing an individual school, then I want rows 45-80 to be seen
(including the one combo box) and I want rows 81-200 to be hidden (the 10
combo boxes for the different schools should be hidden as well). And vice
versa - if the user selects that they represent a school district, then I
want rows 45-80 to be hidden and rows 81-200 to be seen.
I have two option buttons (I inserted these from the same location under
Form Controls that I inserted the combo boxes). I have assigned a macro to
these buttons that hides the appropriate rows based on the selection made
(individual school or district)
I hope that I have better described my situation now. If there is more that
I need to explain let me know. Thank you for your help!