Completed

VBA Excel - Search Box

Hi there,

a really small thing but need help.

Have a list of up to 200 entrys with name of my customer and create via Excel Data Validation a dropdown field. The Problem is i can not search and must scroll 200 entrys up and down to find the correct name.

So i need a VBA Solution.

Maybe with Combo.Box.

The best thing would be if user insert "?" in cell and than Popup will open where i can search for my data.

But mabye you have a better solution...

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: how to create a search box in excel 2016, how to create a search box in excel 2013, vba code for search button in excel, excel search box filter, dynamic search box in excel, create a search box in excel without vba, how to create a filtering search box for your excel data, how to create a search box in excel 2010, vba excel search record excel table, vba excel search line word document, vba excel search list, vba code hide box excel, box excel search data, vba excel search word document, vba word search excel file

About the Employer:
( 4 reviews ) Bannewitz, Germany

Project ID: #16280056

Awarded to:

beltran0404

Hello, I am Luis from Venezuela and I will be more than glad to assist you with your issue. I can create a button to make a window pops up and you search the name. Another solution is with a cell where you write na More

€15 EUR in 1 day
(73 Reviews)
4.9

24 freelancers are bidding on average €23 for this job

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) I am an Engineering Graduate with an MB More

€33 EUR in 1 day
(552 Reviews)
8.1
deepbluetech

Hi, Shall provide you with an Excel VBA based solution which will autofill the search cell from the range of 200 entries. Let me know and we can proceed. Regards, Arul

€30 EUR in 1 day
(211 Reviews)
7.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€30 EUR in 1 day
(222 Reviews)
6.9
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy

€23 EUR in 1 day
(234 Reviews)
6.3
dotsys123

Dear Sir/Madam, Thank you for reading my proposal. I am expert in Admin support, Customer support, eCommerce product listing, Online Marketing and Web Development services . I have following experience of work wh More

€20 EUR in 1 day
(3 Reviews)
5.5
€50 EUR in 1 day
(15 Reviews)
4.6
qasimalikgmail

Dear client, I can create a searchable combobox for that. let me know if it will serve the purpose. Looking forward

€19 EUR in 1 day
(6 Reviews)
3.6
dayakmlt

You want a search box, type a name in that box and matching name and other details should display in main screen/sheet, hope this is your requirement

€19 EUR in 1 day
(14 Reviews)
3.6
vw6767981vw

Hi there I'm [url removed, login to view] of InfoSec with good knowledge in excel and vba. I will hope can help you to do this. Ready to begin.

€14 EUR in 1 day
(13 Reviews)
3.4
prasannjeetp

My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.

€8 EUR in 0 days
(4 Reviews)
1.5
€14 EUR in 5 days
(0 Reviews)
0.0
nairharish

Welcome to my profile. I love to do automation. My capabilities do not limit to the following: - Microsoft applications: Excel, Word, Powerpoint and creating VBA macros on Windows and Mac OS. - PDF Fillable Fo More

€23 EUR in 1 day
(0 Reviews)
0.0
donaldcala

A proposal has not yet been provided

€29 EUR in 3 days
(0 Reviews)
0.0
€24 EUR in 1 day
(0 Reviews)
0.0
angelpatelpro

Hi There, I will do it in 3 hours. It is very easy task for me. Trust me I will not disappoint you. I am new on freelancer but doing this kind of jobs since last 3 years. I think I prove my self.(No one is going t More

€29 EUR in 1 day
(0 Reviews)
0.0
€21 EUR in 1 day
(0 Reviews)
0.0
€23 EUR in 1 day
(0 Reviews)
0.0
MF990

I am working as a full-time Virtual assistant and already performed data entry tasks which includes internet research, skip tracing/data scraping. I once served as a Customer service representative - Email support. Als More

€20 EUR in 1 day
(0 Reviews)
0.0
Yunes079

A proposal has not yet been provided

€29 EUR in 1 day
(0 Reviews)
0.0
€23 EUR in 2 days
(0 Reviews)
0.0