Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Help (2000)

    Ok I need help with an excel project. I am totally lost any help?

    1.Opena new excel workbook
    2. You need to create a workbook that will create an order form for fresh produce pizza
    3. This workbook will need to be made into a template with macros for easy usage. It must be fool-proof and user friendly
    4. It will need an auto-macro asking for employee name, ID and current date (I am so lost)
    5. A macro will then be needed to fill in the produce order form. Things you'll need tomatoes($12 per box) ETC...
    6.. The template will need to show the numbe ordered for each item, it's price per item, charge for each item, and total price.
    7.Grade will be based on macro coding, ease of use, and style

    I am so lost does any one else have a clue i'd appreaciate the help!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Help (2000)

    Welcome to Woody's Lounge!

    That's a tall order, if you'll excuse the pun. Your description is obviously from some kind of assignment. Are you attending an Excel course or something like that? If so, I assume that you have a book or course manual. You state several times that you are lost, but this assignment is not one for beginners, so you should have at least a basic knowledge of Excel before attempting it.

    We can help you with specific questions, but I'm sure you'll understand that we can't do your homework for you.

    I would start by thinking about the layout of the worksheet. Item # 6 in your list gives a hint at the columns you are going to need. The macros etc. will come later. Feel free to post one or more replies in this thread with specific questions.

  3. #3
    New Lounger
    Join Date
    Jan 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Help (2000)

    Yeah, I got the layout of the template down, what i'm stuck on is the macros. I don't understand how I would record a macro to ask for employee id, name, and date.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Help (2000)

    I'm afraid that is not something you can record. One possibility is to use the InputBox function. For example:

    ...
    Dim strEmployeeName As String
    strEmployeeName = Trim(InputBox("Enter employee name"))
    If strEmployeeName = "" Then
    MsgBox "You didn't enter a name!", vbExclamation
    Exit Sub
    End If
    ActiveSheet.Range("B1") = strEmployeeName
    ...

    A more elegant but also more complicated solution is to create a userform. This has to be done in the Visual Basic Editor (Insert | UserForm). You can put labels, text boxes, command buttons etc. on the userform, and you can link text boxes to specific cells on the worksheet by setting their Control Source property.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel Help (2000)

    Hi Manda,

    What could also help other loungers to assist you and solve certain queries more effectively is to attach a sample of the template or workbook that you are working on. If we can see the workbook it is easier to work with you and understand in depth the questions you are asking about the file.

    Complete the layout and take it as far as you can. Then post it as an attachment (ensuring that there is no confidential or sensitive data in it.) Then post any questions you have and we will gladly assist you with anything you are unsure of. This is of course why the forum is here in the first place!

    Hope to hear from you soon... <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Help (2000)

    In addition to the InputBox that Hans gave an example for, he mentioned creating a userform. Here is a nice little primer: Creating a Custom Form in Microsoft Excel

    Steve

Posting Permissions

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