Excel list auto complete in word

**baszer** · 03-03-2013, 12:41 PM

Hello,

I 've got a question. I got a list in excel with plants. Office version 2010.

Now I want to create a form in Word where I can type for example the letters Ro and that all possible plants choises from the Excel file with a Ro in the name (Rose) come up in a dropdown. Now I can click on Rose and than the English name Rose and the Latin name appear on the screen.

Now I always have to type all the names by hand, but I hope this can way faster by doing like I explained.

So my question, is this possible?

**Richard Buttrey** · 03-03-2013, 12:48 PM

Hi,

Are you saying that the word file is linked to an Excel file?

Why is it necessary to have a Word form when you could just as easily have the same look and feel form in Excel and avoid complicating things?

**baszer** · 03-03-2013, 12:50 PM

maybe you are right, and I shouldn't do that. But is it possible to make the search function as I described in excel?

**Richard Buttrey** · 03-03-2013, 01:41 PM

Hi,

Does the attached help you?

**baszer** · 03-03-2013, 03:44 PM

thank Richard for your reply, but if you add another Rose2 to the list, and if you search on Ro than you only get Rose, I would like to have both in the dropdown so you can click the one you need

Is that possible with excel?

**Richard Buttrey** · 03-03-2013, 06:02 PM

Hi,

The first drop down allows you to select anything that's in the list. And since both Rose & Rose2 are present then you can select either

With the second option it's not a drop down that you pick from. Here you enter characters. So if you have two containing 'Ro' how would you want the system to determine which should be used?

The other way to do it would be with a Userform and some macro code. The userform would first capture your characters. The macro would then proceed to extract all the plants that contain those characters into a temporary list. That temporary list would then be used in a cell drop down allowing you to choose as per the first example. That's obviously a bit more complex to build.

**baszer** · 03-04-2013, 03:36 AM

Originally Posted by Richard Buttrey

The other way to do it would be with a Userform and some macro code. The userform would first capture your characters. The macro would then proceed to extract all the plants that contain those characters into a temporary list. That temporary list would then be used in a cell drop down allowing you to choose as per the first example. That's obviously a bit more complex to build.

that's exactly what I mean. So it is possible

I going to give it a try, hopefully it's not that complicated.

**Richard Buttrey** · 03-04-2013, 06:59 AM

Originally Posted by baszer

that's exactly what I mean. So it is possible

I going to give it a try, hopefully it's not that complicated.

OK, Good luck. I remember coding just such a process a couple of years ago for someone.

**baszer** · 03-04-2013, 07:47 AM

are you willing to share it with me?

**Richard Buttrey** · 03-04-2013, 07:59 AM

Hi,

It was written for a particular client with some additional and different features built in.

I'll search the archives and see if I can find it and strip it down to your basic essentials.

Regards