Use and navigate through option button on w/sheet
 

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.

Use and navigate through option button on w/sheet
 

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

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

Use and navigate through option button on w/sheet
 

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

"Dave Peterson" wrote:

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

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

Use and navigate through option button on w/sheet
 

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

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

"Dave Peterson" wrote:

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

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


--

Dave Peterson

Use and navigate through option button on w/sheet
 

Thank you sir !!
I appreciate your HELP.

"Dave Peterson" wrote:

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

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

"Dave Peterson" wrote:

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

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


--

Dave Peterson