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.

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

Don't know if an API solution is possible.

In article ,
"Kalvin Kaligis \(JKT\)"
wrote:

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?

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/...astersLink.htm


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


"Kalvin Kaligis (JKT)" wrote in
message ...

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.