Terminé

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

Compétences : Excel, Visual Basic, Visual Basic pour les apps

en voir plus : 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

Concernant l'employeur :
( 9 commentaires ) Dresden, Germany

Nº du projet : #16280056

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(75 Commentaires)
4.9

23 freelance font une offre moyenne de €23 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(562 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(212 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(234 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(249 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(3 Commentaires)
5.5
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(21 Commentaires)
5.0
qasimalikgmail

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(10 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(14 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(9 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(10 Commentaires)
3.3
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
0.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
donaldcala

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
Yunes079

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0