Combo box in a user form

[fazthfc]

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.

[nilem]

Hi fazthfc,
maybe something like this (for the first part)

Please Login or Register  to view this content.

[sktneer]

While on the Forum in design mode, click on the first combobox --> Press F4 to open Properties --> RowSource --> A5:A35
Do the same for other combobox but change the range reference as per requirement.

[fazthfc]

Great stuff. RowSource works perfectly. Thanks.

[sktneer]

You're welcome.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.