Use and navigate through option button on w/sheet

[TUNGANA KURMA RAJU]

I would like to make a index w/sheet with option buttons to navigateto other
w/sheets , to open user forms and to run macros.for example;
option button1.--goto w/sheet 10
option button2.--goto w/sheet 6
option button3.-- open userform1
option button4.-- run macro1
Is it possible ?
If so how to put optionbuttons on w/sheet and assign functions to them?
Thannks to all mvps and excel experts in advance.

 

[Dave Peterson]

I wouldn't use OptionButtons. I'd just use plain old buttons from the Forms
toolbar.

I'd create macros for each of the first 3 buttons (just like you did for the 4th
button). Then assign each of the macros to the correct button on the worksheet.

 

[TUNGANA KURMA RAJU]

Thanks Peterson,what macro is appropriate?. For my 'goto sheet10' shall I use
hyper link function with option button?

 

[Dave Peterson]

Record a macro when you do it manually.

For just going to another sheet, I'd use something like:

Sub GotoSheet10()
worksheets("sheet10").select
End sub

If I wanted to go to a specific cell, I'd use:

Sub GotoSheet10()
application.goto worksheets("sheet10").range("a1"), scroll:=true
End sub

 

[TUNGANA KURMA RAJU]

Thank you sir !!
I appreciate your HELP.

Record a macro when you do it manually.

For just going to another sheet, I'd use something like:

Sub GotoSheet10()
worksheets("sheet10").select
End sub

If I wanted to go to a specific cell, I'd use:

Sub GotoSheet10()
application.goto worksheets("sheet10").range("a1"), scroll:=true
End sub