I am going to show you how using a combo box can change many aspect of your sheet. to install
a combo box you must have the developer tab on your screen so what you do is you right
click on the ribbon and customze ribbon, and then ensure that the check box next to developer
is checked and press ok. Lets go to the developer tab and then g
o insert and we will select the second one which is are combo box.
what I am going to do is press the alt key and then i am going to draw over a7.
what we need to do is format this so I am going to right click and format control.
We have a little candaia camping adventures now what I have done on the second sheet is
I have created a list of items that you need to bring depending on the season.
in the input range I am gong to minimize the by pressing the little red arrow and go to
the second sheet and select winter and summer. I am going to click on my red arrow again
and I am going to select cell b7 to display the results.
So lets select winter and it produces a 1and summer produces a 2.
we are going to do a index, = index( and we will go the the second sheet to select our
array. and we will select all of the cell with the
items in them. put a comma, back to sheet one based on the
value of cell b7 and I will absolute that by pressing f4,
we would like it to bring up column one of that table.we are going to close the brackets.
and
press enter. we will drag this across.
let us go and select winter. and now the items change
let say we wanted to relate it to something else so we will put in this cell what month
are you going to come. we will go to data, data validation and select
list. when I named these ranges I could not use
one or two because they are reserve numbers so I named them win and sum.I will do an if
function =if( select that one and then I will f4 that now if that equals 1 then we will
display the win list, and if it is not 1 it will be two and the list for sum will be displayed.
And now winter is selected and the months that are displayd are December, January and
February. And for summer June, July
and August. That is how you use a combo box to change
many aspect of your sheet.
Please subscribe