The user form called TimeTracker has a combobox, called cboTask, that has a multi-column dropdown menu. This is to assist users with providing more context to their selection, especially as the dropdown list grows.
Here is a description and issue:
Name of user form: TimeTracker
Combobox under label called 'Task': cboTask
3-column dropdown: From dynamic named range on sheet called "Tasks", which includes Col A (ID), Col B (Task), Col C (PA Unit)
Issue with cboTask: Currently populating the 'Task' field in user form with value in Col A (Tasks!ID)
Fix: Would like this field to be populated instead with value from Col B (Tasks!Task)
I have included the spreadsheet.