Hi,
i created combobox (active control) and want to populate it using values from Table CustomerName:
Screenshot_3.png
1. To have 2 columns from CustomerName : List and Value.
I tried to input named range in field ListFieldRange but this is not working:
Screenshot_5.png
Please help how can i do this.
2. It is possible to attached the combobox to specific cell in table as constant object? (not possible to change it when resizing columns)?
So when table will be resized combobox also should be populated?
3. How to lookup using formula in this combobox?
Goal is to show user different value in a combobox and consume different value attached to selected by user value in same row from source list for combobox (like in Access Combobox)
For example when user will choose "Jacek" in DV or combobox i will see Jacek but the cell will store value "555".
But i do not want to add additional columns for it in table or create separate table to get this.
Please help,
Best,
Jacek
Bookmarks