Urgent Excel help!!

Spitfir3 · 24 Feb 2014 at 20:00

Evening all,

I was wondering if someone could help me out, i'm in urgent need of excel guidance...

Basically, I want a little menu I can insert into a sheet where I have 3 buttons each going to a respective work sheet, also a picture in the background and text would be good...

How do I go about this? I've been faffing around for ages watching tutorials etc and I need it done in like an hour.. :eek:

Cheers!

spydermixx · 24 Feb 2014 at 20:35

Use the Developer tab to insert a couple of buttons (form control option), then assign something like the following VBA to each button:

Sub Macro1()
Sheets("SheetName").Select
End Sub

where "SheetName" is the name of your sheet you want to go to.

Spitfir3 · 24 Feb 2014 at 20:51

spydermixx said:
Use the Developer tab to insert a couple of buttons (form control option), then assign something like the following VBA to each button:

Sub Macro1()
Sheets("SheetName").Select
End Sub

where "SheetName" is the name of your sheet you want to go to.

Cheers! Is it possible to have this form inserted in a work sheet?

spydermixx · 24 Feb 2014 at 21:18

The easiest way to do it imo is have the buttons on the sheet itself as part of the page layout.

It is possible to create something that will open a pop up form with the buttons on, but then you have to start messing about creating a form like so (mainly steps 1-2):

http://www.excel-easy.com/vba/userform.html