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
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