mahaveer somani
New Member
Sir,
i have a range in excel lets say A1:D6 (which may be extend).
and i have a user form having textbox1 and find button and listbox1
my query is that suppose i write "Kumar" in textbox and click on find button then result will be shown in listbox as like :
Ramesh kumar ravi suresh ajay
agarwal kumar vijay ashish aman
vijay kumar sanjay sinha suraj kumar
one excel file is attached herewith.
in short i want to search text (mentioned in textbox1) through the row (but upto Column D) and when the text found the value of that row (from column A to D) will be add in listbox1 automatically.
i have a range in excel lets say A1:D6 (which may be extend).
and i have a user form having textbox1 and find button and listbox1
my query is that suppose i write "Kumar" in textbox and click on find button then result will be shown in listbox as like :
Ramesh kumar ravi suresh ajay
agarwal kumar vijay ashish aman
vijay kumar sanjay sinha suraj kumar
one excel file is attached herewith.
in short i want to search text (mentioned in textbox1) through the row (but upto Column D) and when the text found the value of that row (from column A to D) will be add in listbox1 automatically.
