Atif,

You have many options. The easiest way through this would be to combine the
values into a third column and use a Form combobox with a list range. You
could also do this programatically with a control combobox and combine the
values into one column or two.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Atif" wrote:

Hi All,

Data is in following arrangement

Col A Col B
1 A B
2 A1 B1
3 A2 B2
4 A3

How can I populate a combo box with A and B (catagory), and display
corresponding values in a List Box.