Hi all. I have a userform to enter data consisting of batch no, category, variety and supplier.

Here is some sample inputs

Batch Category Variety Supplier
01 food chips macdonalds
02 drink coke own brand
03 dessert pie mr kipling
04 food burger burger king
05 drink milkshake macdonalds
etc etc

the batch input in userform is a text box.
All the rest are list boxes.
I populate them on initalisation with rowsources with listindex set at -1.

What i want to do is after i type in the batch no. the listboxes populate the current selection i.e.. if i entered 03 in batch text box dessert, pie and mr kipling would all be selected in respective listboxes.

is this possible.

Hope explained it ok.