+ Reply to Thread
Results 1 to 3 of 3

Automatically check box once name selected from dropdown list in a userform

Hybrid View

coach.32 Automatically check box once... 07-19-2013, 12:16 AM
Solus Rankin Re: Automatically check box... 07-19-2013, 12:37 AM
Solus Rankin Re: Automatically check box... 07-19-2013, 12:38 AM
  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    288

    Automatically check box once name selected from dropdown list in a userform

    In my Userform that I have created, I have a dropdown box for the employee to select their name.
    Once this happens the employee can then select 1 of 3 shifts for each day.
    From the employees list there are 2/3 people who are part time.
    Is it possible that when these 2/3 people select their own name that the part time box automatically becomes checked?
    Once the part time box is checked it automatically selects the only shifts the Part timers can work.
    Thank you for any help you may be able to give me.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Automatically check box once name selected from dropdown list in a userform

    If not 'MyComboBoxName'.Value = "'1/3 persons name'" then
    'MyCheckBoxName'.Value = 1
    end if
    This would go in your ComboBox change event.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Automatically check box once name selected from dropdown list in a userform

    Please note- if the checkbox code operates on a clicked_event, this will not trigger the event.

+ 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: 12
    Last Post: 02-16-2013, 10:53 PM
  2. macro to unhide row when a dropdown list item is selected
    By ahng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2012, 07:17 AM
  3. Automatically set all CURRENCY format to only one selected in one dropdown list
    By jasonofshanghai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2012, 08:42 AM
  4. enter data automatically in userform depending on dropdown selection
    By ImboJones in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2010, 12:38 AM
  5. Any way to get the index of a selected item from a dropdown list?
    By chitian5057 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 05-13-2010, 02:41 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