Closed Thread
Results 1 to 3 of 3

Making User form populate spreadsheet

Hybrid View

  1. #1
    Registered User
    Join Date
    03-14-2015
    Location
    New Hudson, MI
    MS-Off Ver
    2013
    Posts
    11

    Making User form populate spreadsheet

    I work in a small fire department, and recently got tasked with updating our payroll spreadsheet to alleviate some of problems we've been having with calculating payroll. I understand basic excel formulas, and I created a form that would could be used to add runs, along with who was present for that run. I'll add an attachment to what I have so far, but basically each run will have it's own number, a date, time, and hours paid for the length of that specific call. I have my rows set up as personnel, and columns as runs. The form has the inputs for the run information, and check boxes for each individual employee, so I want to set it up so whoever is entering the data can check off who was there, and the hours paid will populate in that persons cell for that run. Any advice would be greatly appreciated! Test Master Payroll Macro-Enabled.xlsm

  2. #2
    Registered User
    Join Date
    03-14-2015
    Location
    New Hudson, MI
    MS-Off Ver
    2013
    Posts
    11

    Re: Making User form populate spreadsheet

    I've been looking through some online tutorials, but I really don't seem to have a great grasp on it.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Making User form populate spreadsheet

    OP has posted in the CS forum, so this thread is now closed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Making one user form appear on top of the other based on positions
    By sur4j in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2014, 11:09 AM
  2. Calling a user form initialize sub when entering the form to populate combobox...
    By regupnorth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2012, 07:24 AM
  3. Help Making New User Setup Form:
    By HOMERSlMPSON in forum Excel General
    Replies: 2
    Last Post: 02-08-2011, 11:47 AM
  4. Making User form available to all Workbooks
    By ct56 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2010, 03:16 PM
  5. making a form all a user ever sees
    By collierd in forum Excel General
    Replies: 2
    Last Post: 01-16-2007, 06:25 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