Listbox change event to return two values to different cells

Hi,

I have a list box with four column and a linked cell, however when a user changes the linked cell and updates the lisbox or vice versa I also want another cell to update with data from column 4 on the list box.

Can this be done through vba code? does it need to be as I know the linkcell is currently used and I dont see a way to link 2 cells in the propertiues of the listbox.

Any help would be greatly appreciated thanks.

Andy

Yes the second cell value would come from the same data just a different column. I dont want a formula in the cell as the retuned value will be copied out by users to a different program.
The current linked cell refers to column 1 and the new cell would display the value in column 4.

Sorry, I am not understanding this.
I the listbox changes the linked cell, what will this code change, should I reference a cell/range that this code puts the value of the 4th column into?

ie the current linked cell is called acctnum and it is filled with the value in column 1.
I also want a second linked cell called acctname to be filled with value in column 4.
is this possible, considering the values will be derived from the same listbox?

Thanks
Andy