Đã hoàn thành

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

Kỹ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem thêm: 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

Về Bên Thuê:
( 4 nhận xét ) Bannewitz, Germany

Mã Dự Án: #16280056

Đã trao cho:

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 Thêm

€15 EUR trong 1 ngày
(73 Đánh Giá)
4.9

24 freelancer đang chào giá trung bình €23 cho công việc này

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 Thêm

€33 EUR trong 1 ngày
(552 Đánh Giá)
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 trong 1 ngày
(211 Đánh Giá)
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 trong 1 ngày
(222 Đánh Giá)
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 trong 1 ngày
(234 Đánh Giá)
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 Thêm

€20 EUR trong 1 ngày
(3 Đánh Giá)
5.5
€50 EUR trong 1 ngày
(15 Đánh Giá)
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 trong 1 ngày
(6 Đánh Giá)
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 trong 1 ngày
(14 Đánh Giá)
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 trong 1 ngày
(13 Đánh Giá)
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 trong 0 ngày
(4 Đánh Giá)
1.5
€14 EUR trong 5 ngày
(0 Đánh Giá)
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 Thêm

€23 EUR trong 1 ngày
(0 Đánh Giá)
0.0
donaldcala

A proposal has not yet been provided

€29 EUR trong 3 ngày
(0 Đánh Giá)
0.0
€24 EUR trong 1 ngày
(0 Đánh Giá)
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 Thêm

€29 EUR trong 1 ngày
(0 Đánh Giá)
0.0
€21 EUR trong 1 ngày
(0 Đánh Giá)
0.0
€23 EUR trong 1 ngày
(0 Đánh Giá)
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 Thêm

€20 EUR trong 1 ngày
(0 Đánh Giá)
0.0
Yunes079

A proposal has not yet been provided

€29 EUR trong 1 ngày
(0 Đánh Giá)
0.0
€23 EUR trong 2 ngày
(0 Đánh Giá)
0.0