hey
i've already created a button(form). How do i link this button to another
worksheet in the same workbook?

thank you

Hey, what are you talking about?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"blackktifool" wrote in message
...
hey
i've already created a button(form). How do i link this button to another
worksheet in the same workbook?

thank you

I was thinking of creating a link from one worksheet in excel, to the other.
Can this only be done using hyperlinks?
As I have already created a form button.
I wanted it to link to another worksheet when i click it.
Is it possible?

Thank You

There are two articles available in VBA help that you should probably read.
One is "Using ActiveX Controls in Documents" and the other is "Using ActiveX
Controls in Sheets". To access these articles, open VBA help and type "Using
ActiveX Controls" in the search box. Afer you have read the articales, maybe
you can be more specific about what you want to do.

"blackktifool" wrote:

I was thinking of creating a link from one worksheet in excel, to the other.
Can this only be done using hyperlinks?
As I have already created a form button.
I wanted it to link to another worksheet when i click it.
Is it possible?

Thank You

If you add a command button to a sheet, then (while still in design
mode) you can double click it to go to the vba editor. In the command
button's Click routine, insert

sheets("name of sheet to jump to").activate

HTH,

David

On Jul 21, 9:30 am, blackktifool
wrote:
I was thinking of creating a link from one worksheet in excel, to the other.
Can this only be done using hyperlinks?
As I have already created a form button.
I wanted it to link to another worksheet when i click it.
Is it possible?

Thank You