I am using the following successfully to validate a form combo box [using the "RowSource" parameter] against a table on a work sheet with a single column :-
LookupData!Table_Query_from_harglive9
Does anybody know how to alter this to specify a specific column when the Table has more than one column. Either defining Column number or Name to be used. Tried numerous syntax but none work.
EG LookupData!Table_Query_from_harglive9[Column Name] etc.
Many thanks.
