Originally Posted by
DMT Dave
Thanks WGM, this only a test file so what i am trying to see if possible, like Access add 2 fields to a combo column 0 and 1
column 0 would be equivalent to column B on the excel and column 1 would be equivalent to column C
Not sure if Excel is similar, i can't validate 2 columns to 1 column on Excel, like mentioned, never worked with Excel code, this is also just a test file.
So in the list, if i chose what is row 9 which would be Monaco, then i am trying to tell column H to be Circuit De Monaco from row 9 (column C)
I don't know if possible for a listbox to look up values in column C from row 9 if row 9 was selected then put that data to another cell
hope i have made sense