List box - active X type

[rterke]

I have made an excel workbook, which i intend to use for keeping my inventory data.

I have made the sheet one as control sheet where I have made some buttons, to change the name of the subsequent sheets etc.

Now I want to add a Catagory list box, and then add some items in it based on my products. How to add that. My list box is of Active-x type.

What code i need to write to add the list. Then how can i access the list in cell B3 the subsequent sheets. I have total of 100 sheets.


Thanks