+ Reply to Thread
Results 1 to 2 of 2

Creating a User Form Template with Dynamic fields

  1. #1
    Registered User
    Join Date
    08-11-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    3

    Creating a User Form Template with Dynamic fields

    Hi!

    I need to build a form template using excel that a User can fill up in building an article for an online webpage.

    Using the template, the User can select the types of fields applicable in building the form.

    Perhaps we can think of it like selecting widgets in building an online webpage?

    Basically it should look something like this:

    Title: [XXX]
    Summary: [XXX]
    Body:
    (For this portion, the user can select using different "tools" to build the body. Eg. To add a dropdown list / free text / radio button.)

    Scenario: when the User wants to start building the body portion using dropdown, they can select a button saying dropdown and this will populate the field out for the user to fill up.

    Sorry if this is confusing, but hopefully someone has a clue on this!

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    06-07-2014
    Posts
    213

    Re: Creating a User Form Template with Dynamic fields

    It is always a good idea to attach a concept workbook or drawing (both of these without personal information) with what you have in mind so others can elaborate and try to assist you.

    Based on what you have said, see the attached workbook which has been created. You can build on it further. There is a button that can enable you to open a form to create and save new articles and another button which can open a form to view previous articles. The two sample 'articles' in the attached are basic general articles; one talks about the car and the other about the computer. They are in the attached for illustrative purposes only.

    Cheers!
    Attached Files Attached Files
    Last edited by chin67326; 01-23-2016 at 03:23 PM.
    If you have received help from a user, please feel free to Rep that person.
    Also, do remember to click Thread Tools and mark your thread as solved, if you have achieved a solution to your thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-12-2014, 03:05 AM
  2. [SOLVED] User Form Required Fields
    By hhpack3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2014, 04:32 PM
  3. Freeze user form while creating many dynamic controls
    By richard.briggs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-15-2014, 04:14 AM
  4. User Form Date fields error out
    By Turtle2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-21-2013, 09:17 PM
  5. User form which having some fields to be entered only once.
    By Kiran2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2012, 08:36 AM
  6. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 AM
  7. Best way to fill user form fields
    By evanzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2008, 09:41 PM

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