up vote 2 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
75% accept rate
I don't think there's any functionality close to a dynamic search suggestions in excel. At best, excel will suggest the first matching item, or a drop-down of choices in Data-validation. It may be possible to implement one in VBA, but you will need to intercept every keystroke (up, down, enter, etc.) and program your own dynamic suggestion box (a small form). So a very manual and cumbersome endeavor. Likely not worth the trouble at all. It will be interesting to see if someone has attempted this before. – mtone Dec 17 '11 at 20:29
feedback

1 Answer

up vote 0 down vote

I would create a list of items you generally purchase on another sheet, then use data validation to put a drop down in the item column with all the items.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.