print result based on combo boxes

  • Thread starter Thread starter kaon
  • Start date Start date
K

kaon

Hi all,

I am not sure about the question has been asked before, and I foun
nothing from the this forum, so I better post the question for hel
again. :cool:

I have 2 combo boxes, namely ComboA and ComboB. ComboA contains
values: "Install", "Disconnect" and "Restore", while ComboB contain
years (1999, 2000, ...., 2005).

Currently I have 2 columns, in which each column refers to a differen
file. I want to display the data based on the choices of ComboA an
ComboB on the 2 columns.

Anyone can help me to solve this?

Thanks
 
Kaon

Is it imperative that you use two added combo boxes? What you appear to be
doing in filtering based on criteria. If this is the case, check out
Data>Filter>Autofilter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Maybe I need to clarify the problem.

ComboA is used for displaying unit price of each stock in differen
years. They are placed on the same sheet but different columns. I wan
to group them into the comboA by year, which in turn is placed onto
new sheet.

To illustrate:

1999 .. 2000 .. 2001
Item X 2 .. 4 .. 1
Item Y 1 .. 2 .. 4

.. = some more rows in between

The comboA have choices of 1999, 2000, 2001. When choice is chosen, th
corresponding unit price of each item are displayed.

Hope you get what I mean.
Thanks
 
Back
Top