Search for stack number using input

**jhard** · 09-03-2008, 04:59 PM

I am attempting to create a workbook that allows our employees to search for the status of a product by putting in the stack number (sort of like a serial number) and the sheet be brought up. I would like to have the employee type in a stack number and the cursor go to the location of the matching stack number (Similar to a Find function).

Thanks for the help.

**VBA Noob** · 09-03-2008, 05:21 PM

Maybe with an event macro.

Right click sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

VBA Noob

**martindwilson** · 09-03-2008, 05:41 PM

try this code
insert in standard module then assign to a forms button on first page

Please Login or Register  to view this content.

**Cheeky Charlie** · 09-03-2008, 05:51 PM

Hi guys,

I don't mean to sound a smart alec with this, what's wrong with find? It already has a keyboard shortcut, Ctrl+f!

As far as I can tell, Martin's code is simply a (neatly written and executed) code of Excel's native find functionality.

I am not trying to be clever - what's the point/difference?

Cheeky Curious Charlie

**VBA Noob** · 09-03-2008, 05:54 PM

what's wrong with find? It already has a keyboard shortcut, Ctrl+f!

Depends on the OP requirement

My method runs when a correct code is entered which is quicker than pressing Ctrl + F then options > search workbook

VBA Noob

**martindwilson** · 09-03-2008, 07:11 PM

1.it looks nice!
put into workbook open voila!(which incidently i forgot to suggest)
2.besides which my excel 97 doesnt have that function.
3. most users dont even know 1/10th of excels native functions.
i have macros that do all sort of things,just tell the user to click button its far easier than teaching them say go to edit/special/last cell.
they are there just to use the dang thing not worry about how it's done.
4. it also gives op an insight to what can be achieved,and they may go on to be the next Ron de Bruin(all praise his name,we're not worthy: lol)

**jhard** · 09-08-2008, 08:25 AM

Thanks VBA and Martin. This will work perfectly. Cheeky to the point of why I didn't want to use a simple Cntrl - f function - VBA abd Martin hit the point on the head. I have a workforce of non computer literate people and the simpler I can make it, the better.

Thanks again.