+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : UserForms

Hybrid View

  1. #1
    Registered User
    Join Date
    05-13-2011
    Location
    Birmingham
    MS-Off Ver
    Excel 2007
    Posts
    78

    UserForms

    Hi,

    My company is new and dont have a customized software to complete tasks. We use excel for accounting/invoicing. Each time we have to manually enter the fields. My friend told me that we can take advantage of excel/word userform features that will improve efficiency. The task is I want an excel file which will ask questions on opening (date, item, unit price, qty) and on completing the form it will post all entries in the table accordingly. Attached is the file for your convenience.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by nlm; 06-20-2012 at 02:17 AM.

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: UserForms

    hi, you could start with this
    http://www.excel-vba-easy.com/vba-us...excel-vba.html
    and for yr example see the attached file, hope it helps you!
    Attached Files Attached Files
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1