VBA code for Combo Boxes

[GN0001]

The code should take care of this task that when an end user enters some characters in the combo box, it suggests us whole string.

For example if enter b, combo box should suggests all the names starting with b.

Any code?

I appreciate your help.

Thanks,
GN

 

[SirJB7]

Hi, GN0001!
It's not possible unless in user forms.
Regards!

 

[Deepak]

Hi,
If you wish live search in xl then goto http://chandoo.org/forum/threads/search-in-different-sheet-and-return-in-the-first.15749/#post-95115

 

[GN0001]

Hi, GN0001!
It's not possible unless in user forms.
Regards!

 

[GN0001]

I wonder If I want to continue, are you there to help me?

I need a couple of combo boxes and two or three text boxes and the result to be shown in a grid or whatever control is designed to show the result.

GN0001

 

[Deepak]

Hi GN0001,
Would you pls share your sample file to assist better.

 

[GN0001]

I will post my file, I need to insert a combo box that shows the employee,
Perhaps If I want to get suggestion on the names, I have to enter a text box, which when I enter characters into the text box, it gives me suggestion in Combo box.
The solution on the top doesn't work for my purpose. I need to learn this technique on the combo boxes.
Regards,
GN0001

 

[Somendra Misra]

Hi GN0001,

Reading your first post, please go through below link.

http://chandoo.org/forum/threads/dropdown-based-on-search-string.15410/

Please see @Debraj comment & file.

Regards,