excel autocomplete combo-box with on-selection event
- by IttayD
Hi,
I have an excel sheet for groceries. One column is the name, another is whether to buy it or not (checkbox) and another is the amount.
I'd like to have a widget in the top row so that I start typing an item's name and it shows a list of matching items that I can select from, or if I continue to type and there's only one item, completes its name. When the last item is selected, other widgets show the amount, which I can edit and clicking 'check' will check the item in the list.
I know this is kind of very specific, but am hoping someone can at least get me started.
Thank you,
Ittay