Hi all,

I am trying to create a userform that requires the user to enter three pieces of information. The first is a name, the second is a piece of equipment and the third a date. I have managed to set the form up with a combo box for name and equipment but I'm struggling with the code.

I would like the first combo box to use the values that have been entered in cells A5:A35 which contains a list of names. I would like the second combo box to use the values from HT5:HT15 which is a list of different pieces of equipment. I can't figure out the code to put these values in automatically.

Finally, when the user hits confirm I would like the data that they have selected to go into the first available row in column HU.

Any help, either with the first or second part would be greatly appreciated.

Many thanks in adavance.