How To Write Find Function Using Macro

[YONG0074]

Hi all,

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

I have a probably very very simple problem to you all but really hope that someone can help me in this!! 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]

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]

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]

Use Manage Attachments in the Go Advanced reply section to post a sample workbook.

[YONG0074]

Hi,

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

Warm regards,
Kitara

[YONG0074]

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]

Hi Kitara,
Welcome to VBAX

Here's 2 options to consider

Regards
MD

[YONG0074]

Hi MD!!

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

Really appreciated you help very much. Thank you!


Warm regards,
Kitara