Hi everyone,

I am new to VBA and generally use the "forms" toolbar to create filters and
the like but I want to start to use "VBA Forms" instead to simplify the way
the users sceen looks.

To that end I am trying to find out how to populate a list or combo box with
a set of pre-defined items, then when the user submits the chosen values
these then populate a field on the sheet. I can do this simply with a text
box but that means the user has to know the options available.

It's a simple form with two boxs 1 for branch and 1 for stock catagory the
branchs & catagories are fixed hence why I think a list box would be ideal
and thought would be the simplest option for the users.

Any help would be greatly appreciated.

Tia


Jonathan