+ Reply to Thread
Results 1 to 1 of 1

Macro to polpulate fields

  1. #1
    Registered User
    Join Date
    05-13-2011
    Location
    Bournemouth
    MS-Off Ver
    Excel 2003
    Posts
    44

    Macro to polpulate fields

    *** See additional remarks under original post ***

    Morning all

    I have a spreadsheet that tracks the activity of staff based on 8 different options. This main sheet then feeds further sheets that then provide the various stats we need for each staff member.

    What I'm after if someone can help is that when the workbook is opened, a window pops up asking if we want to add new data. If the answer is no, them it closes and we can work on the workbook as required.
    If the answer is yes, a further window would open with an option to insert a date, and 2 columns. One would list the staff initials as per row 2 - SB LW MV etc and the second column would then have an input option to insert one of the 8 options (FL OD OF AD etc). Once the boxes are populated, it would then add a 1 into the relevent column against the relevent date in column B and as long as my conditional formatting works, the rest of the cells would be populated with zero's. The conditional formatting hasn't copied over onto this attachment, but at the moment I scroll along each row each day and insert the 1's and the zero's do appear.

    I realise it's a big ask, but if anyone can help, it would be greatly appreciated.

    regards

    *** I have managed to create the user forms, I just do not know how to get the forms to pop up initially and also then to relate which text box provides which bit of info ***
    Last edited by CTCoperations; 06-06-2011 at 10:50 AM. Reason: Attachment changed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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