Textbox with multiple search records

[vmjan02]

I have a textbox3 and all the name records in sheet1. I am not sure as once the user enters a name in the textbox3, then code should search the all the results and should display with multiple records.

eg:-
sheet1 column C have names as
X
Xy
XXy
AA
AB
ADS
CC

if user enters as "X" in textbox3 then all the records related to it should be displayed "X,Xy,XXY" and user can select any one of the record.

Any idea

 

[JackDanIce]

@vmjan02 I think you mean auto-suggest or auto-complete, but I do not believe this is possible (easily) in VBA

Same way if the user enter first 2 words in the me.textbox3 then there it will display by itself and user select the right word. I hope I am clear now.

@My Aswer Is This
I guess

Always trying to learn more and help others where I can

doesn't extend to questions about code styles/practices to learn from each other?

Perhaps if others reading this thread, they could explain benefit of declaring a long variable and passing a string to it, just curious to understand this as haven't seen it before or is commonly used.