Search for serial number, pull information, and then submit

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.

Re: Search for serial number, pull information, and then submit

Quote from yegarboy;586694

What version of excel are you using? Im using 2007. The worksheet code can easily be changed. On my version it cycles through top to bottom without error.

I am using the same version, I can cycle to the top but once you hit the top result and hit the up button again it shows a debug error. Same if you do it with the bottom.

I am also getting a lot of weird things going on when cycling up, it seems to be going up no matter the result, it will even go up in to the labels if it wants to.

Re: Search for serial number, pull information, and then submit

Quote from yegarboy;586697

Hmm try thisforum.ozgrid.com/index.php?attachment/42532/ after you hit search the button changes to find next.

I am going to have to continue testing tomorrow night, I have to clock out and catch some Z's, have to be up early in the morning. I appreciate the help and hope to see you on tomorrow night.

Re: Search for serial number, pull information, and then submit

Quote from yegarboy;586697

Hmm try thisforum.ozgrid.com/index.php?attachment/42532/ after you hit search the button changes to find next.

So this one works fine unless you have no results then it errors out with a debug error.

Re: Search for serial number, pull information, and then submit

Quote from yegarboy;586753

Ok i added some error trapping and reworked the search so it stays in colum c no matter what. I couldnt make it bug out but see if you can lolforum.ozgrid.com/index.php?attachment/42538/

This one works perfect I can't get it to glitch out.