JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
Not having much joy with this. There are some non-VBA suggestions but I can't get them to work how I need.
In an input sheet, I have a defined table (used for input area).
In this table, on a a specific column, I want to create a searchable drop-down box only when the user selects a cell in that column, where the user can start typing into a search box and the selectable list shrinks to show only values containing the characters typed. This needs to occur for each row in the given column in the table.
In a separate data sheet, I have a defined table with the entire list of values the drop-down should have.
Finally, after a value has been selected by user, I want to add 2 formula to the adjacent columns on the right.
I want to avoid using UserForms, any suggestions?
TIA,
Jack
Not having much joy with this. There are some non-VBA suggestions but I can't get them to work how I need.
In an input sheet, I have a defined table (used for input area).
In this table, on a a specific column, I want to create a searchable drop-down box only when the user selects a cell in that column, where the user can start typing into a search box and the selectable list shrinks to show only values containing the characters typed. This needs to occur for each row in the given column in the table.
In a separate data sheet, I have a defined table with the entire list of values the drop-down should have.
Finally, after a value has been selected by user, I want to add 2 formula to the adjacent columns on the right.
I want to avoid using UserForms, any suggestions?
TIA,
Jack