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