+ Reply to Thread
Results 1 to 4 of 4

Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet

  1. #1
    Registered User
    Join Date
    08-31-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet

    Hi All,

    Being a real unexposed sort to VBA/macros I'm stuck & would appreciate any basic direction/assistance.

    I have a staff leave planner spreadsheet. When the name of the person, leave type & dates are generated I want the 'key' (a letter) to be entered into the spreadsheet date area to update manning numbers and hours (range FP7-GE7 & FP50-GE50 in worksheet). There are 4 worksheets, three of which are for various shifts (so I can alter data to suit each worksheet as soon as I get one worksheet functioning) and the forth is a index key. I need the letter of the related leave type to correspond to the selected leave type in the Userform to then appear in the calendar area of the spreadsheet (so that day/person is not counted) and I can then set up conditional formatting to better display this on the spreadsheet.

    I am completely out of my depth as to how to enter the Userform code to generate the data based on the persons name and the leave type into the dates entered. Because I am so green I don't even know how to properly setup initialization of the form.

    If you know of any good information websites or tutorials on youtube I'd love to look at them. I've spent so many hours on google and I'm not getting anything but more confused.

    I hope this is enough information. Spreadsheet is attached, current coding (or lack of) below:

    Private Sub ComboBox1_Change()

    End Sub

    Private Sub ComboBox3_Change()

    End Sub

    Private Sub CommandButton6_Click()

    End Sub

    Private Sub DTPicker1_Enter()
    DTPicker1.Value = Now()
    End Sub

    Private Sub CommandButton7_Click()

    End Sub

    Private Sub CommandButton8_Click()
    Unload Me
    End Sub

    Private Sub DTPicker2_Enter()
    DTPicker2.Value = Now()
    End Sub

    Private Sub Frame1_Click()

    End Sub

    Private Sub UserForm_Click()

    End Sub

    Private Sub UserForm_Initialize()

    End Sub



    Again many thanks for any help - Marie
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,058

    Re: Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet

    Hi Marie

    I made a start on this for you.

    The only button that I haven't programmed is the New Name

    I'd need to know where the ID number would come from and what you would want in the database.

    Enjoy
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,058

    Re: Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet

    I have modified this slightly to make it a lot more intuitive.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-31-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet

    Thank you Mehmetcik, this has given me a great starter point beyond where I was!

    You're certainly far cleverer than I Thank you so much for your time and assistance!!

+ 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. Staff holiday planner
    By Partridge in forum Excel General
    Replies: 6
    Last Post: 08-04-2017, 09:05 AM
  2. [SOLVED] Match staff name and date then import data from matched row (Example attached)
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-26-2012, 10:33 AM
  3. Replies: 3
    Last Post: 08-07-2011, 02:30 AM
  4. [SOLVED] how many staff have 1 skill, how many staff have 2 skills, etc.
    By ch90 in forum Excel General
    Replies: 3
    Last Post: 10-27-2005, 11:05 AM
  5. annual leave planner for approx 100 staff members
    By wally in forum Excel General
    Replies: 1
    Last Post: 03-22-2005, 08:06 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