C
Chip Pulitzer
I have the following problem...
I want to make a combo box drop-down list that permits the user to select a
month. The selected month can then be referenced on other sheets in the
workbook. Currently, I've got twelve rows containing: January, February,
etc... I also have a combo box that references those twelve cells, and
outputs the selection to a dummy cell someplace. So when you use the box to
select, say, April, the value "4" is output to the dummy cell. Now I'm
stuck, even though it seems very simple. How do I use the value in the dummy
cell to pull out the appropriate month. I created a NAME for the list called
"Months," expecting I could write something like "=Months($B$1)" where $B$1
is the dummy cell, but this doesn't work. Any suggestions?
Thanks in advance,
Chip
I want to make a combo box drop-down list that permits the user to select a
month. The selected month can then be referenced on other sheets in the
workbook. Currently, I've got twelve rows containing: January, February,
etc... I also have a combo box that references those twelve cells, and
outputs the selection to a dummy cell someplace. So when you use the box to
select, say, April, the value "4" is output to the dummy cell. Now I'm
stuck, even though it seems very simple. How do I use the value in the dummy
cell to pull out the appropriate month. I created a NAME for the list called
"Months," expecting I could write something like "=Months($B$1)" where $B$1
is the dummy cell, but this doesn't work. Any suggestions?
Thanks in advance,
Chip