how do i create a menu

trigger · Apr 18th, 2002, 07:13 AM

hey
Im currently studying AVCE ICT. One of our units is a spreadsheet solution. I need to create a menu, but how?
cxan you help me at all?
thankyou
trigger

Ian Mac · Apr 18th, 2002, 07:19 AM

Quote:

On 2002-04-18 06:13, trigger wrote:
hey
Im currently studying AVCE ICT. One of our units is a spreadsheet solution. I need to create a menu, but how?
cxan you help me at all?
thankyou
trigger

Could you elaborate a little, I assume you don't mean for a restaurant.
A drop down list? Combobox?

trigger · Apr 19th, 2002, 09:40 AM

I need a first screen which is a menu that allows people to click and go straight to an invoice, customer list or stock list. It also neds a print option as well. I am doing this for a drumstick supplier. I have been told the workbook must be menu driven for easy use.

Joe Was · Apr 19th, 2002, 09:44 AM

Lookup the "Case" statement in the Excel VBA editor help. JSW

Ian Mac · Apr 20th, 2002, 02:17 AM

Quote:

On 2002-04-19 08:40, trigger wrote:
I need a first screen which is a menu that allows people to click and go straight to an invoice, customer list or stock list. It also neds a print option as well. I am doing this for a drumstick supplier. I have been told the workbook must be menu driven for easy use.

With regards to an Invoice you could have a drop down list that pulls information into the rest fof the sheet usind look up. There wouldn't be the need to navigate the workbook ( bring the information to you, not you to it), this will also help in the fact the a print button would only need to be on one sheet.

Look for help on Data Validation on this site.

Mudface · Apr 20th, 2002, 04:32 AM

Also, have a look through Excel help (and this site) for hyperlinks- should be easy enough to create a few internal ones to go to the various sheets in your workbook.

trigger · Apr 21st, 2002, 04:45 AM

thanks for the help
I know i have to use lookups on the actual invoice but the exam board as told me the first page must be a menu that allows you to either go to the invoice, update the customer list or update the stock list.

Tom Schreiner · Apr 21st, 2002, 06:34 AM

Hi Trigger...
If you are looking to create a "Main Menu" type sheet, there are several options...
The easiest was already stated. Just use hyperlinks.
Or you can use command buttons, pictures, drawing objects, ect...
Are all of your sheets in the same workbook?
Tom

dpolson · Apr 21st, 2002, 07:19 AM

It dedends on what you want the menu choices to do:

[1] If you want a choice to take you to another location (another sheet in the same workbook, or another workbook), hyperlinks are a great choice. On the Excel menu bar click INSERT, HYPERLINK, and then plug in the cell, worksheet & cell, or workbook & worksheet & cell that you want the hyperlink to take you to.

[2] If you want a choice to run a macro, just link the macro to a BUTTON from the FORMS menu bar by: [a] creating the macro, then [b]click BUTTON on the FORMS menu bar, then [c] place your button where you want it, and [d] assign the macro you want run when you click the button. You can rename the button...just right click and Edit Text.

Hope that helps.

Dale

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

Apr 18th, 2002, 07:13 AM	#1
trigger New Member Join Date: Apr 2002 Posts: 7	hey Im currently studying AVCE ICT. One of our units is a spreadsheet solution. I need to create a menu, but how? cxan you help me at all? thankyou trigger

Apr 19th, 2002, 09:40 AM	#3
trigger New Member Join Date: Apr 2002 Posts: 7	I need a first screen which is a menu that allows people to click and go straight to an invoice, customer list or stock list. It also neds a print option as well. I am doing this for a drumstick supplier. I have been told the workbook must be menu driven for easy use.

Apr 19th, 2002, 09:44 AM	#4
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	Lookup the "Case" statement in the Excel VBA editor help. JSW

Apr 20th, 2002, 04:32 AM	#6
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Also, have a look through Excel help (and this site) for hyperlinks- should be easy enough to create a few internal ones to go to the various sheets in your workbook.

Apr 21st, 2002, 04:45 AM	#7
trigger New Member Join Date: Apr 2002 Posts: 7	thanks for the help I know i have to use lookups on the actual invoice but the exam board as told me the first page must be a menu that allows you to either go to the invoice, update the customer list or update the stock list.

Apr 21st, 2002, 06:34 AM	#8
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Trigger... If you are looking to create a "Main Menu" type sheet, there are several options... The easiest was already stated. Just use hyperlinks. Or you can use command buttons, pictures, drawing objects, ect... Are all of your sheets in the same workbook? Tom

Apr 21st, 2002, 07:19 AM	#9
dpolson New Member Join Date: Apr 2002 Posts: 17	It dedends on what you want the menu choices to do: [1] If you want a choice to take you to another location (another sheet in the same workbook, or another workbook), hyperlinks are a great choice. On the Excel menu bar click INSERT, HYPERLINK, and then plug in the cell, worksheet & cell, or workbook & worksheet & cell that you want the hyperlink to take you to. [2] If you want a choice to run a macro, just link the macro to a BUTTON from the FORMS menu bar by: [a] creating the macro, then [b]click BUTTON on the FORMS menu bar, then [c] place your button where you want it, and [d] assign the macro you want run when you click the button. You can rename the button...just right click and Edit Text. Hope that helps. Dale