visual basic.

nathan_cox · May 8th, 2002, 03:01 AM

how do i have a workbook containing 3 sheets, but have 2 buttons on the first sheet which will jump to the other sheets? one button for sheet 2 and one for sheet3. ive tryed using the edit with visual basic but i cant get it.

Nobby · May 8th, 2002, 03:03 AM

Why don't you add the buttons to your toolbar instead of in the sheet?

Nobby

Iain Lewis · May 8th, 2002, 03:15 AM

Right click on it if it is from the Forms toolbar.

If it is from the Control Toolbox toolbar then go into Design Mode ( first button on the Control Toolbox ) and double click on your Button.

crimlet · May 8th, 2002, 03:40 AM

The simple way is to set up the two button and assign different macros to them. The code would be
Sheets("Sheet2").Select

for the 1st macro

Sheets("Sheet3").Select

for the 2nd macro

sen_edp · May 8th, 2002, 04:12 AM

hello Nathan

Another simple way to do it is by inserting Hyperlinks. No vba needed.
Go to Menus ->insert->hyperlink->Named location in file .

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 03:01 AM	#1
nathan_cox New Member Join Date: May 2002 Posts: 1	how do i have a workbook containing 3 sheets, but have 2 buttons on the first sheet which will jump to the other sheets? one button for sheet 2 and one for sheet3. ive tryed using the edit with visual basic but i cant get it.

May 8th, 2002, 03:03 AM	#2
Nobby Board Regular Join Date: Feb 2002 Location: United Kingdom Posts: 68	Why don't you add the buttons to your toolbar instead of in the sheet? Nobby

May 8th, 2002, 03:15 AM	#3
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Right click on it if it is from the Forms toolbar. If it is from the Control Toolbox toolbar then go into Design Mode ( first button on the Control Toolbox ) and double click on your Button.

May 8th, 2002, 03:40 AM	#4
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	The simple way is to set up the two button and assign different macros to them. The code would be Sheets("Sheet2").Select for the 1st macro Sheets("Sheet3").Select for the 2nd macro

May 8th, 2002, 04:12 AM	#5
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello Nathan Another simple way to do it is by inserting Hyperlinks. No vba needed. Go to Menus ->insert->hyperlink->Named location in file .