Log in

View Full Version : How To Write Find Function Using Macro



YONG0074
04-21-2010, 06:30 AM
Hi all,

I just found this cool and useful forum in solving problem related to VBA! :cloud9:

I have a probably very very simple problem to you all but really hope that someone can help me in this!!:help Thank you

I have many different reference no. ( like S123456) in different spreadsheets in a workbook. I need to write a code that which allow me to just click a button, then enter the relevant reference no. and then will be able to locate the no. i need in the spreadsheet.

Yup, i know that i can just used the Crt-F function for this, but it will required to change "search column" from sheet to work book. This might slightly more steps for more elderly person to carry out the searching.

Really hope that i can get some help in this. THANK YOU.

Warm regards,
Kitara

Philcjr
04-21-2010, 06:48 AM
Kitara,

WELCOME to VBAX

Question:
1) What Column are the "reference numbers" in?
2) Do you want to type in the "reference number" or select for a list?
3) Any chance of you posting a workbook/example?

Phil

YONG0074
04-21-2010, 07:36 AM
Hi Phil,

Thanks for the offering of help.

1) The reference no. is in column C.
2) Ya, will prefer to type in the reference no.
3) How can i post an example in this forum?

Sorry i am quite new in posting in forum.


Warm regards,
Kitara

mdmackillop
04-21-2010, 07:51 AM
Use Manage Attachments in the Go Advanced reply section to post a sample workbook.

YONG0074
04-22-2010, 08:29 AM
Hi,

Attached is an example of the file. Thank a lot for the time and help

Warm regards,
Kitara

YONG0074
04-25-2010, 12:13 AM
Use Manage Attachments in the Go Advanced reply section to post a sample workbook.

Hi MD,

I have posted a example of the workbook. If i need to find a reference no. "K32138" located at rack 3 at the 3rd spreadsheet, how should i write the code to find it?

Thank a lot and appreciate your help.


Warm regards,
Kitara

mdmackillop
04-25-2010, 03:57 AM
Hi Kitara,
Welcome to VBAX

Here's 2 options to consider

Regards
MD

YONG0074
04-25-2010, 06:14 AM
Hi MD!! :content:

Thank you a lot for your help and extra fixture you have put inside the workbook! :bouncy:

Really appreciated you help very much. Thank you! :biggrin:


Warm regards,
Kitara