Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: how do i create a menu

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?
    "Have a good time......all the time"
    Ian Mac

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    "Have a good time......all the time"
    Ian Mac

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  9. #9
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •