Solved: Populate Specific Column Cell based on ListBox Selection

[tccmdr]

Gurus, I need your help

I have a multicolumn Listbox populated by a worksheet range.

When I select an item in the Listbox it's value populates a Textbox and an Input Box allows a value entry to another Textbox.

I need to transfer the Inputbox value to another worksheet containing the Listbox values, however, the Listbox values are column fields in the worksheet

I've attached the workbook

[Bob Phillips]

I presume you want to transfer the miles to the Data sheet, but a new row every time, or only if there is no room in any existing row?

[tccmdr]

That is correct.

The miles(kilometres) would populate the first available cell in the column matching the Fleet ID Number

[Bob Phillips]

Okay, try this

[tccmdr]

Mr X.........getting close now

What I've found is:

If you enter a mileage for the same ID more than once.....no problem, populates perfectly in the correct column, however,

with the next ID chosen their mileage populates every cell, in the correct column, instead of just the first available empty cell in the correct column

I think it has something to do with the "For Next" statement

[Bob Phillips]

Here you go

[tccmdr]

Well done Mr.X

I owe you one