+ Reply to Thread
Results 1 to 2 of 2

Enter Range of Data using a Form entry

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Enter Range of Data using a Form entry

    Good afternoon everyone

    I am using a form to enter data into a datasheet which then drives reports etc. I have some very basic VBA in the background.

    I am curious to know if anyone has ever used a form to enter a range of Data, like using a template of tasks that are then added to a datasheet.

    Eg .... If I select the entry "Drive Car" from a drop down list in my form, then the information placed into the datasheet of tasks is as follows:

    Open Door
    Sit in Drivers Seat
    Put on Seat Belt
    Start Car
    Put foot on the brake
    Put in Drive
    Put foot on Accelerator

    These entries would be a named range on a separate sheet called "Drive Car", so choosing the Name of the Range from the Drop Down would fill out the items in the datasheet as a list of items

    I can get the task sheet to list the items by using a basic if statement, however the data sheet would be an ongoing list that can be added to at any stage, so the above example would make up 7 task lines in a longer list.

    I have attached a basic sheet to show what I am after. I would like to select an item from the Yellow drop down list and have it put the list of tasks for that item in Columns A and B. I will have a "Submit" Button to confirm the entry.
    If I then select another item from the yellow drop down, I want those tasks to be added beneath anything already in Column A and B, so it is an ongoing list.

    Hope this makes sense.

    Warm regards

    Darren.
    Attached Files Attached Files
    Handy things to keep in mind:

    Click *, if my suggestion has helped you
    If your problem is solved, then please mark the thread as SOLVED

    Sharing is Caring .... spread the knowledge

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Enter Range of Data using a Form entry

    If a little piece of VBA isn't a problem to you then try next example.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. [SOLVED] VBA Data Entry Form to find first empty row in a specific range
    By frankytheman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-07-2020, 01:42 PM
  2. [SOLVED] VBA - Match formulae to enter data on a pre-existing row using a form entry
    By Mlanger575 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-01-2016, 09:37 AM
  3. Need VBA to enter data from user form in TOP ROW of range
    By gusdonnelly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2016, 01:22 PM
  4. User Form Data Entry Specific Range Start
    By simpdogg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2016, 10:37 AM
  5. Replies: 2
    Last Post: 06-07-2013, 09:08 AM
  6. Use form submission to enter data both in the form and not in the form
    By tsamuels in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 10:06 PM
  7. Data Entry Form (similar to default Excel Data>Form)
    By tonydm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 02:59 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