I have an Excel database template that I am making; it has 4 sheets. The first sheet is the “Front page” it is the only sheet that I want anyone to see, I don’t want access to the other sheets with the data on them. The first sheet has a button that brings up a userform with a search box and a listbox. The next three sheets have the same headings on 7 columns. Here’s what I need my user form to have 2 separate search boxes one that searches column c and one that searches column d for the information. I alson need there to be a reset button which will clear the search to start over, and a next button incase the first record retriecved isn’t the one I want. I need my listbox to show the information from all columns. Right now my userform only has one search box and the listbox brings back which sheet the information is on. I can click on the sheet in the listbox but then it brings me to the sheet.
Company Customer Number First Name Last Name Address Phone E-Mail