Mar 04 2022 02:32 AM
Below is the screenshot of what I mean by autocomplete.
What I want is to be able to see the previously entered price of an item in the list but while I am doing that I should be able to have the autocomplete as well.
Mar 04 2022 10:45 AM
@dalmiamayoite , there is a workaround possible :-
Step 1 : While entering the data, enter bearing name and price in same cell separated by a distinct character which would never appear in the bearing name. A comma if possible, or another suitable character. Then the price would also be shown while entering data for easy entry.
Step 2 : When the data entry is complete, use Text to Columns option in the Data tab. Go for Delimited > Next > [Select that character as Delimiter] > Next > [Set Format if required] > Finish
Step 1 image :-
Step 2 image :-
After Step 2 :-
Mar 04 2022 05:48 PM
Mar 04 2022 08:25 PM
Solution@dalmiamayoite Use a Range that includes all of the data for the ListFillRange - in my example L6:N8 and set the BoundColumn (2) in this case and ColumnWidths to appropriate values
In the drop-down list, you will then see
And the LinkedCell will be populated with data from the BoundColumn of the Selected item. With appropriate code in the ComboBox Change event you could have the data from the other columns inserted into the desired spaces.
Mar 04 2022 08:25 PM
Solution@dalmiamayoite Use a Range that includes all of the data for the ListFillRange - in my example L6:N8 and set the BoundColumn (2) in this case and ColumnWidths to appropriate values
In the drop-down list, you will then see
And the LinkedCell will be populated with data from the BoundColumn of the Selected item. With appropriate code in the ComboBox Change event you could have the data from the other columns inserted into the desired spaces.