kriten
New Member
- Joined
- Jan 14, 2005
- Messages
- 3
Hello
I have a workbook comprising of 20 or so sheets.
On one of the sheets I have buttons each with the title of one of the other sheets.
I am trying to work out some code to read the text from the button that is
clicked and then use it to select the sheet named in the button.
I can do each button individually but I would like to use the same bit of code for each button, thus cutting down on the amount of code needed to be written.
Hope someone has some ideas as my VB knowlledge is just at the infant stage.
Thanks in advance.
Kriten
I have a workbook comprising of 20 or so sheets.
On one of the sheets I have buttons each with the title of one of the other sheets.
I am trying to work out some code to read the text from the button that is
clicked and then use it to select the sheet named in the button.
I can do each button individually but I would like to use the same bit of code for each button, thus cutting down on the amount of code needed to be written.
Hope someone has some ideas as my VB knowlledge is just at the infant stage.
Thanks in advance.
Kriten