+ Reply to Thread
Results 1 to 2 of 2

Macro and form controls

  1. #1
    Registered User
    Join Date
    09-08-2022
    Location
    Providence, Rhode Island
    MS-Off Ver
    Office365
    Posts
    1

    Question Macro and form controls

    Hello!

    I've been googling around trying to find what I was looking for but maybe my search terms weren't good enough.

    Essentially what I am trying to do is make what I though would be simple dock time tracker.

    I'm trying to set it up so depending on what is entered in on the sheet when someone presses the dock/release buttons it will copy the text that was entered and then time stamp it.

    I was able to get the button macro to work; however, I cannot seem to get it to take the information along with the time stamp.

    Ideally I'd like to be able to put a truck schedule onto it, and then just click dock/release to make it easier for everyone on the floor.

    Sorry if this has been asked before, or if I'm not getting my idea across well enough.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,405

    Re: Macro and form controls

    to give you a solution it would help if you upload your workbook with the macro in it.
    see big yellow banner and follow the instructions
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. Form Controls and ActiveX Controls - Option Button
    By mmchaley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2021, 05:10 PM
  2. Form Controls v. ActiveX Controls
    By Richard Stringfellow in forum Excel General
    Replies: 2
    Last Post: 01-11-2016, 08:06 PM
  3. macro needed to hide form controls
    By excelhelpseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2015, 10:56 AM
  4. Form Controls / Active X controls to record and log information in a seperate sheet
    By marcbarnett in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2014, 05:00 AM
  5. Replies: 1
    Last Post: 05-01-2014, 05:15 PM
  6. Create mutiple combo box form controls using Macro
    By booo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2010, 07:51 PM
  7. ActiveX Controls vs Form Controls
    By Alex in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 04:50 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