+ Reply to Thread
Results 1 to 4 of 4

VBA Check Box to return crew members name instead of true or false.

  1. #1
    Registered User
    Join Date
    11-09-2014
    Location
    iowa
    MS-Off Ver
    2010
    Posts
    8

    VBA Check Box to return crew members name instead of true or false.

    So I am once again out of my league. I've been googling and searching on here for hours trying to figure out how I can take a UserForm and return a group of names based of the users selection. At the moment my code is set up to have the user select a service from a drop down menu, which is then posted to a cell and any combination of three check boxes. I haven't been able to think of a way to get the check boxes to function though.

    The checkboxes are there so I can see which employees were on a job site. I want to be able to search the info later to compare which teams of guys work best together. In addition the employees are only paid for time on the job site. When they use the userform it auto calculates the amount of time they spent on the job. Ideally I would be able to determine payroll based off the same info, If and only If I can get the crew names to print on the sheet in a searchable manner.

    Idk what to do folks. any ideas would be appreciated.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA Check Box to return crew members name instead of true or false.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    11-09-2014
    Location
    iowa
    MS-Off Ver
    2010
    Posts
    8

    Re: VBA Check Box to return crew members name instead of true or false.

    Sorry Xladept, I was working on loading this in when I got distracted with a possible resolution.

    The image below is the only thing my crews will see until they press one button or the other.
    Crew View.PNG

    When they press "Ignition Off" the Userform "frmOff" will run. This is what it looks like.
    IgnitionOff.PNG

    After they fill the form out the info is printed in a hidden sheet. Which looks like this.
    Results of Off.PNG

    When the crew finishes working they will click "Ignition On" the UserForm "frmOn" will run. This is what it looks like.
    IgnitionOn.PNG

    After they finish the results now look like this. (I should mention the Date and Time In are autopopulated as well as the time out. I'm a little scatterbrained and some titles still need changed around. sorry
    Results of On.PNG


    I currently have no code in for the checkboxes at all. I was preparing to write an If statement that set up a macro to run if the box is clicked as true. The Macro would paste the persons name in the cell. Still not sure how I could get multiple names pressed.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA Check Box to return crew members name instead of true or false.

    Hi Wheelie,

    Can you post a sample spreadsheet? With or without code the spreadsheet is a big help to us

+ 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: 06-05-2014, 03:15 AM
  2. Check font color and return a True or False
    By randolphoralph in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-21-2013, 09:13 PM
  3. Check four conditions return TRUE or FALSE
    By mkvassh in forum Excel General
    Replies: 6
    Last Post: 11-16-2009, 07:26 AM
  4. Replies: 3
    Last Post: 07-15-2006, 05:20 AM
  5. [SOLVED] Function to return True/False if all are validated as True by ISNU
    By Tetsuya Oguma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 06:30 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