Results 1 to 6 of 6

Form to fill in data help

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-17-2013
    Location
    London, England
    MS-Off Ver
    Microsoft 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
    Posts
    155

    Form to fill in data help

    Hi all,

    I am looking at having a form on the attached spreadsheet that gets the user to add the data on it and not directly onto the spreadsheet, I started to create a Form on the sheet as you can see if you press ALT - F11 and have it how I want it by following an online tutorial, Only issue is I have no idea what VBA to add to the buttons do what I want them to do.

    So I want the DATE text input box to firstly only allow the format 00/00/0000, Then the e number (stands for employee number), Start time and end time need to be in this format 00:00:00, Issue Area/Base During Outage and Equipment Provision will be drop down lists, INC number allows them to put an Incident number in and then Comments goes into the "issue notes" section. I would like it so you press a button or ENTER and this data populates the relevant sections on the sheet, There may be multiple entries.

    I know this is a massive task and I think it is way out of my realm of excel skills and was hoping someone here could help me with it?

    Thanks in advance.
    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. Fill pdf form from excel data
    By Konexcelmath in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2020, 03:26 PM
  2. Using excel as a data base with a form to fill in
    By OillyBob55 in forum Excel General
    Replies: 1
    Last Post: 09-18-2015, 03:21 AM
  3. Auto Fill form data
    By Bufftstar_2001 in forum Excel General
    Replies: 1
    Last Post: 07-07-2015, 01:00 PM
  4. Form to Fill in Column Data
    By lyla22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-24-2015, 05:36 PM
  5. fill in the same form from a table data
    By Howaida in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-13-2009, 07:36 AM
  6. [SOLVED] how to get a data form to fill you own exel sheet (was data-form
    By erik van buijtenen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2006, 12:35 PM
  7. Auto fill form with data from worksheet
    By mg_sv_r in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2006, 10:40 AM

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