+ Reply to Thread
Results 1 to 9 of 9

Form Controls / Active X controls to record and log information in a seperate sheet

  1. #1
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2007
    Posts
    27

    Form Controls / Active X controls to record and log information in a seperate sheet

    Hi - this may be simple but hope its not a stupid question

    I am looking to create a form which will record information in a seperate sheet based on user selections.

    The first criteria / option the user could select will contain 4 options (user should be unable to make multiple selections in this list)

    The second criteria / option the user could select will contain 12 options (user should be unable to make multiple selections in this list)

    Once both options have been filled the user will click submit, the form resets itself and the information is recorded in a seperate sheet.

    The process can be repeated up to 50 times a day and I want to be able to view the information in a list.

    Any help will be appreciated.

    Thanks Guys

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Form Controls / Active X controls to record and log information in a seperate sheet

    I am looking to create a form...
    What KIND of form? On a sheet, userform???


    the user could select will contain 4 options
    Optionbuttons?



    12 options (user should be unable to make multiple selections in this list)
    Listbox?


    Help us help you!
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Form Controls / Active X controls to record and log information in a seperate sheet

    Hi sorry my explanation wasnt very good.

    I will attach an example which hopefully will explain more

  4. #4
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Form Controls / Active X controls to record and log information in a seperate sheet


  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,198

    Re: Form Controls / Active X controls to record and log information in a seperate sheet

    I'd do it like this
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Form Controls / Active X controls to record and log information in a seperate sheet

    Thanks Kyle,

    Can you elaborate on what you used / did so I can refer back to it?

    Thanks

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,198

    Re: Form Controls / Active X controls to record and log information in a seperate sheet

    I've uploaded a workbook? So I'm a bit confused, specifically, what are you asking?

  8. #8
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Form Controls / Active X controls to record and log information in a seperate sheet

    Basically how you done it

  9. #9
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,198

    Re: Form Controls / Active X controls to record and log information in a seperate sheet

    Created dynamic ranges for the two listboxes so adding items is easy.

    Set the source range of the listbox to the dynamic range

    Added a macro that takes the values of the 2 listboxes and adds them to the next available row in the data sheet along with the date and time

    Have you looked at the code?

+ 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: 05-01-2014, 05:15 PM
  2. Need to apply Form Controls or Active X Controls to Pivot Table
    By bdmw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2013, 04:16 PM
  3. Additional Form or Active X controls
    By scott28 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2012, 12:41 PM
  4. Enable/Disable Form controls on a worksheet (not Active X Control)
    By vaniravi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2012, 07:42 AM
  5. [SOLVED] ActiveX Controls vs Form Controls
    By Alex in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 04:50 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