Suoritettu

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...

Taidot: Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 9 arvostelua ) Dresden, Germany

Projektin tunnus: #16280056

Myönnetty käyttäjälle:

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 Lisää

€15 EUR 1 päivässä
(75 Arvostelua)
4.9

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

€33 EUR 1 päivässä
(562 arvostelua)
8.2
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 1 päivässä
(212 arvostelua)
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 1 päivässä
(234 arvostelua)
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 1 päivässä
(249 arvostelua)
6.5
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 Lisää

€20 EUR 1 päivässä
(3 arvostelua)
5.5
€50 EUR 1 päivässä
(21 arvostelua)
5.0
qasimalikgmail

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

€19 EUR 1 päivässä
(10 arvostelua)
3.9
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 1 päivässä
(14 arvostelua)
3.6
supergana

Hi - I am very proficient in excel having worked on it for over 15 years. Given the details i can start work immediately and deliver in a day.

€23 EUR 1 päivässä
(9 arvostelua)
3.3
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 0 päivässä
(10 arvostelua)
3.3
€8 EUR 1 päivässä
(2 arvostelua)
0.8
€14 EUR 5 päivässä
(0 arvostelua)
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 Lisää

€23 EUR 1 päivässä
(0 arvostelua)
0.0
donaldcala

A proposal has not yet been provided

€29 EUR 3 päivässä
(0 arvostelua)
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 Lisää

€29 EUR 1 päivässä
(0 arvostelua)
0.0
€24 EUR 1 päivässä
(0 arvostelua)
0.0
€21 EUR 1 päivässä
(0 arvostelua)
0.0
€23 EUR 1 päivässä
(0 arvostelua)
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 Lisää

€20 EUR 1 päivässä
(0 arvostelua)
0.0
Yunes079

A proposal has not yet been provided

€29 EUR 1 päivässä
(0 arvostelua)
0.0