Results 1 to 5 of 5

Dynamic form (No VBA)

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2019
    Location
    New York, NY
    MS-Off Ver
    MS Office 2013
    Posts
    8

    Dynamic form (No VBA)

    Hello all,

    I'm helping a friend to do a simple excel-based form template without using VBA.

    The idea is this:

    1. A simple form for ordering supplies. The catch for me is that each supply section has images as references for the user filling out the form. I've already formated a file to print or fill in excel (Tab 1 in the sample attached).
    2. The ideal next step is: after the user completes the order, the user then clicks something like an "order/complete/send" button. This command would then generate a summary of the order, with no images (on another tab), so the next user can print it (the summary). (see tab 2 in the attached file).

    I am not sure if this idea is even worth exploring because:
    a) the images are plenty and, I think, making this file cumbersome (I had to resize the file to attach it here, since the orignal file is already 1.2MB with just 6 pages); and b) I am not sure what process to follow when a new order comes in; do I create a template file and "save as" every time there is a new order? What if I need to add new items to the (template) form as they become available?


    Any thoughts would be much appreciated.

    PS: my first thought was to tell my friend to buy software to do this, but I am not sure if they are able to go for that option yet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamic form in Excel with formulas?
    By Tinzoulin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-08-2018, 05:54 PM
  2. Dynamic Labels in Form
    By akshaysudhir in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2015, 04:42 AM
  3. Dynamic Order Form
    By Fremaan in forum Excel General
    Replies: 3
    Last Post: 05-06-2014, 09:48 PM
  4. Create a Dynamic User Form
    By abhishekchak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2012, 06:53 AM
  5. Dynamic form with VBA code
    By ChrisNor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2009, 05:48 AM
  6. Dynamic Form in Excel
    By lisa6538 in forum Excel General
    Replies: 15
    Last Post: 01-11-2007, 03:57 PM
  7. dynamic form updates
    By Shawn G. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2005, 01:05 PM

Tags for this Thread

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