Search Records by ID

**z-eighty2** · 06-17-2013, 05:24 PM

Hello,

I want to make a Search Box (userform) with an option to " Search by Customer ID" and a text box to display search information and a command button "Search"

I want it should search the entire Sheet and display all records of that customer when I put " Customer ID " in the search box. It should display information which is in Column number 3(Date), Column number 5(NAME) & Column number 6(Payment) of that Customer. Information should be displayed in "Text Box" of the form.

I hope you guys will be understanding what I mean.

Regards
z-eighty2

**FDibbins** · 06-17-2013, 05:36 PM

this can be done with a few countif() and index/match formulas, you dont need VBA

upload a sample workbook showing what you are working with (no sensitive info), and we can help you put something together
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.