+ Reply to Thread
Results 1 to 4 of 4

interactive form

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    CT
    MS-Off Ver
    Excel 2007
    Posts
    5

    interactive form

    Hello, Help! I have been scouring your forums and the web trying to create an interactive form that fills out another spreadsheet in another worksheet via a submit button. I am a total noob to this type of programming. right now it gets stuck on the very first line that was put in by excel itself (Sub SUBMIT). So far i have this written. Is it at all going to work? Am i on the right path? Thanks in advance for even looking at my post
    Please Login or Register  to view this content.
    Last edited by Flee0723; 02-04-2014 at 05:58 PM. Reason: Added Code Tags

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: interactive form

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    02-03-2014
    Location
    CT
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: interactive form

    Near Miss Logproto.xlsNear Miss Logproto.xls
    I am trying to have "Form" become a desktop link that when filled out, auto-fills the spreadsheet we use to track these reports. I made the form "Trial" to experiment on. When i have a working program i will modify the macro to link it to the actual form rather than the trial. All of our previous years sheets are there to look at as well. Right now it is all manual entries that becomes time consuming every week.
    Last edited by Flee0723; 02-06-2014 at 01:48 PM.

  4. #4
    Registered User
    Join Date
    02-03-2014
    Location
    CT
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: interactive form

    Does anyone know if i am on the right path?

+ 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. New to Access, need help creating an interactive form
    By AlphaSkidz in forum Access Tables & Databases
    Replies: 2
    Last Post: 11-13-2013, 11:43 AM
  2. Excel: how to create an interactive popup form
    By illo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2013, 11:34 AM
  3. Interactive Form
    By Rysky75L9 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-15-2012, 09:24 AM
  4. Need help creating an interactive web form with Excel
    By ttkoshi in forum Excel General
    Replies: 2
    Last Post: 04-01-2011, 09:44 AM
  5. Interactive Form
    By Ctech in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2006, 09:10 AM

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