View Full Version : Solved: Populate Specific Column Cell based on ListBox Selection

06-07-2007, 05:28 PM
Gurus, I need your help:bow:

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:help

I've attached the workbook:whistle:

06-08-2007, 01:18 AM
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?

06-08-2007, 01:37 AM
That is correct.

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

06-08-2007, 01:40 AM
Okay, try this

06-08-2007, 06:31 AM
Mr X.........getting close now: pray2:

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:doh:

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

06-08-2007, 06:54 AM
Here you go

06-08-2007, 07:22 AM
:clap: :clap: :clap:

Well done Mr.X

I owe you one:beerchug: