EXCEL VBA COMBO BOX/DROP DOWN LIST

[Neeraj1990]

HELLO TO ALL
I AM NEW ON THIS FORUM, SO IN CASE IF I MADE A MISTAKE ASKING QUESTIONS IN IMPROPER WAY. KINDLY APOLOGIZE.
SO MY QUERY IS.
I HAVE TWO COLUMNS IN MY EXCEL SHEET, ONE CONTAIN LIST OF ITEMS ANOTHER CONTAINS ITS RATES/PRICES.
NOW I WANT TO GENERATE A INVOICE FORMAT
IN WHICH I LL SHOW INVOICE, CUSTOMER NAME, COMPANY NAME AND LIST OF ITEMS PURCHASING.
FOR THAT I WANT TO CREATE A SEARCHABLE DROP DOWN MENU. IN WHICH IF I WRITE ANYTHING RATE SHOULD BE SHOWN AUTOMATICALLY.
HOW CAN I PREPARE THIS?
I CAN EASILY DO THIS USING OFFICE 365. IN OFFICE 365 DATA VALIDATION SHOWS SEARCHABLE DROP DOWN MENU. JUST LIKE WE CREATE USING VBA. BUT
IN OTHER VERSION OF OFFICE DATA VALIDATION BOX SHOWS COMPLETE LIST, U NEED TO CHOOSE FROM LIST BUT YOU CAN NOT SEARCH. JUST LIKE IF YOU
TYPE J YOU SHOULD GET LIST OF ALL ITEMS AUTOMATICALLY STARTING WITH J. BUT HERE IT IS LITTLE BIT TRICKY. HELP ME TO SOLVE THIS

 

[Peter_SSs]

Welcome to the MrExcel forum!

I AM NEW ON THIS FORUM, SO IN CASE IF I MADE A MISTAKE ASKING QUESTIONS IN IMPROPER WAY. KINDLY APOLOGIZE.

It does take a little while to know your way around and what is expected so for a start, please take a look through all the Forum Rules but in relation to your question here, particularly #14, noting that it applies to both posts and thread titles. Please remember that for any future threads/posts.