How to make autocomplete textbox in excel cell in VSTO C# add in -

How to make autocomplete textbox in excel cell in VSTO C# add in -

i developing excel vsto add together in, , newbie in addin development. found can add together hyperlink command cell straight , can handle event on follow.

worksheet.hyperlinks.add( rangetoholdhyperlink, string.empty, hyperlinktargetaddress, "tip", "label");

what want add together automplete text box (show autocomplete text on key downwards event) in specified cells next picture.

i know creating dropdown cell setting info validation list c#. don't want utilize because doesn't show on key downwards event , dropdown list info limitted. , can't find related solution google, please help me if has done snippet. alot.

i suppose can add together namerange command cell. has several events, change. can add together functions event. http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.namedrange.aspx hope works.

c# excel vsto add-in