Autocomplete on combobox

[Fr0sT]

Hi guys

I am contacting you for help regarding data validation / combobox for my shops in Colombia (on office 2007, that will be shared on a network).
I would appreciate your help because I have been trying to get this combobox working for a while now…

On the following URL you will find the excel file: http://www.speedyshare.com/file/Kkym...fice-2007.xlsx
-in the sheet “informe diario”, I would like to have autocomplete on the data validation for columns “cliente” and “producto” (the data for "cliente" can be found on another sheet “clientes y descuentos”, same for “producto” data can be found in “lista de precios”).

I really hope you can help me, because without autocomplete I will lose a lot of time…

Thanks in advance.

Kind regards.

Seba

P.S.: It has to work in office 2007 (am not able to upgrade/downgrade office versions)

[Barbara Excel]

Hi Fr0st

I believe this will sit your needs

http://www.contextures.com/xlDataVal10.html

Regards
Barbara Excel

[Fr0sT]

Hi Barbaram I already tried everything on the internet including: http://www.contextures.com/xlDataVal10.html
Is there anyone that can quickly do it for me? I am sure it will take 5min if you know how to do it...

[JBeaucaire]

This is more what you need.... http://blogs.office.com/b/microsoft-...-controls.aspx


That link will help you get your Controls Tools visible and then you add the ActiveX ComboBox quickly. Give that a try.

[Fr0sT]

Still not workin, can you please take a look at it?
Thanks a lot.