Edit Find by Macro?

[umrebelfan69]

I am building a sheet for cataloguing parts. i dont want to have to insert new rows everytime another part comes in. What i want to be able to do is just keep on enterning them as they come in on the next available line. I have assigned codes to what department the parts are designated for use in. If ineeded something coded with "F" then I can use the EDIT>FIND function to be able to search the codes and only scroll thru the returns for "F".

My question is that i would like to make this more friendly to people who dont use Excel on a daily basis. I would like a macro which would select the column that contains the code, this part I have already wrote, but then i would like it to automatically open up the EDIT>FIND menu. This may not be possible, but if it is I know that the people on this board know how to make it do it.

Thanks in advance for any help on this matter

Darryle
umrebelfan69@yahoo.com

[VBA Noob]

Any of these lines should call the find dialog box

Please Login or Register  to view this content.

Or you could use a input box. Examples on links
http://www.ozgrid.com/VBA/find-method.htm
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

HTH

VBA Noob

[umrebelfan69]

VBA Noob

Thank you, those worked like a charm. This is a great sight, i knwo enough about Excel to get myself into trouble. Thanks again