Building Custom AutoComplete

[Kalvin Kaligis \(JKT\)]

In one of my project, it is required in excel to built
auto-complete when typing an entry in a cell. It is also
required that the autocomplete data-source will come from
sql server.

Is there anybody that can give me a hint, how to
accomplish this? is it possible can be done or is there
any alternatives?

Thank you very much.

 

[J.E. McGimpsey]

It can't be done via VBA since macros are suspended while in Edit
mode.

Don't know if an API solution is possible.

 

[Colo]

Does a validation function make sense?
http://www.interq.or.jp/sun/puremis/colo/code/041.htm

I know it's tricky but as JE wrote, while in Edit modewe cannot handle Excel
via VBA.

--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters'

URL:http://www.interq.or.jp/sun/puremis/colo/CellMastersLink.htm
mailto:[email protected]

/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/