Hi everyone you have another Mr Excel virgin here!!
Firstly want to say what a great message board system going on here...so much information and knowledge its incredible!! Keep it up guys!!
Now down to my question...I have searched for the answer but being very new to the whole world of Excel and VBA i thought it would be easier to just ask!!
I have designed a workbook that contains details of various software companies. There are numerous work sheets each sheet being specific to one company. The work sheet tab names are labled with the software companies name.....
Zebra Computer, Casetrack, Videss, Peapod ...and the list goes on!!! About 30 sheets in total.
What I am after is to create a function on the first page so that the user can input the software company name and click search and the function locates the relevant worksheet and makes it active.
From searching the site I know this is very possible...Its just putting it into practice. Is there a code that would enable me to do this? Would the code be linked to the search command button?
Any advice would be grately appreciated.
Thanks in advance for helping me out with this guys.
Dai
Firstly want to say what a great message board system going on here...so much information and knowledge its incredible!! Keep it up guys!!
Now down to my question...I have searched for the answer but being very new to the whole world of Excel and VBA i thought it would be easier to just ask!!
I have designed a workbook that contains details of various software companies. There are numerous work sheets each sheet being specific to one company. The work sheet tab names are labled with the software companies name.....
Zebra Computer, Casetrack, Videss, Peapod ...and the list goes on!!! About 30 sheets in total.
What I am after is to create a function on the first page so that the user can input the software company name and click search and the function locates the relevant worksheet and makes it active.
From searching the site I know this is very possible...Its just putting it into practice. Is there a code that would enable me to do this? Would the code be linked to the search command button?
Any advice would be grately appreciated.
Thanks in advance for helping me out with this guys.
Dai