Re: Search for serial number, pull information, and then submit
Quote from yegarboy;586691
There isn't a way that im aware of that can run 2 searches at once. Here is what i mean.
The first time you press the search button it searches for the text. when it finds it, it activates that cell. Then populates the other cells to your form. You cant add a second search from the same button. Pressing it again just repeats the same search. Thats where the spin button comes in. It can move the active cell up or down. It does the exact same thing as the first search with the bonus of control over what you search. I don't see how pressing an extra button is that hard.
I understand what you mean but when you reach the last result that the up button uses it hits a debug error same with the down button.
Also, since you are specifying to add ALL of the worksheets to the combo box it is adding the worksheet "Entry" which is irrelevent.