UserForm/ RowSource (using combo boxes)

[Squirrel]

Using a userform and need to user separate sheets in the workbook to accomplish the task. Code first:

Please Login or Register  to view this content.

The problem comes with adding to columns 5 and 7. I'm not sure I know how to properly use RowSource.

Basically I need to get the row of the information from the selected choice in a combo box and then input into columns 5 and 7 different info from those rows. All on a different sheet.

If you need more info let me know.

Thanks.

[royUK]

Looks like you should be using ListIndex not RowSource. Remember ListIndex starts at zero so you must add 1

[Squirrel]

ListIndex solved my problem...had to use +2 for it.