Sep 15 2017 03:16 AM
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.
[Apologies if duplicated but last post seems to have disappeared]
Many thanks.
Sep 18 2017 07:52 AM
SolutionSep 19 2017 08:47 AM
Many thanks for the information Jan.
Your solution works well.
Just to point out I got it working like you implied, by naming the table column and then refering to this in the "RowSource" property. Can you explain why using the "Row Source" is frowned upon, as opposed to your method.
Thanks Again Andy.
Sep 20 2017 06:39 AM
Jul 03 2020 10:41 PM
thanks for the tip, but how can i make the listbox updated at the same time @Jan Karel Pieterse
Sep 18 2017 07:52 AM
Solution