Hi,

I am trying to create a template for user to identify what categories
does the product fit into.
I believe that Combo Box is the way to do it, but i cant get it to
display on the right cell...

eg. ColA Col B
Row1 product category(combo)
Row2 apple
Row3 Car
Row4 Cat
Row5 Books

I used a combox in B1 where user can choose between Fruits, Animals and
Miscellaneous, but it only display 1,2,3 on B2 and wont move to the
next row.

Is there a way to show the category value in the approprite box?
ie. select B3, click on the combo box, select the category and then the
value will be displayed on B3?

and same as B4, B5, B6....etc??

Thanks.
Elaine.