PDA

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



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

Bob Phillips
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?

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

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

tccmdr
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:*)

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

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

Well done Mr.X

I owe you one:beerchug: