+ Reply to Thread
Results 1 to 6 of 6

Linking checkbox to cell based on combo box choice

  1. #1
    Registered User
    Join Date
    07-20-2017
    Location
    San Diego, CA
    MS-Off Ver
    2010
    Posts
    20

    Linking checkbox to cell based on combo box choice

    Good morning,
    I have been working on several projects and one keeps me up at night trying to figure out what type of script I need to write. I have a list of names in column "A" that will be changing based on other things going on. I have a userform with both a combo box and a check box. combo box already updates with anyone that is in column "A". What I am trying to do is based on the name I select from the combo box, I want the check box to link to the cell to the right (column B). the check box in this case is related to being qualified for a job.
    for instance, if I have 2 people (kevin and derrick) and kevin is qualified, derrick is not. I would like when I select kevin under the combo box that the check box will be checked (because the cell to the right of kevin is true), but I could unselect the checkbox to change the cell's value.

    The best I can think of is doing a vlookup like I have done in other areas and adding the linking to the cell option after the lookup. I'm not sure how to write it. Any help would be appreciated.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Linking checkbox to cell based on combo box choice

    Hi, the world has gone haywire based on assumptions, so a sample file with some dummy data would help.
    Show what you want in it.
    You know what they say about I assume .... it makes an A S S out of U and M
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    07-20-2017
    Location
    San Diego, CA
    MS-Off Ver
    2010
    Posts
    20

    Re: Linking checkbox to cell based on combo box choice

    I didn't see my email stating I had a reply so sorry for the late response. Thanks for the input, I just posted this again (same title) with an attachment. Please take a look.

  4. #4
    Registered User
    Join Date
    07-20-2017
    Location
    San Diego, CA
    MS-Off Ver
    2010
    Posts
    20

    Re: Linking checkbox to cell based on combo box choice

    oh, I just figured out how to post it here. let me know what you think, thank you!
    Attached Files Attached Files

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Linking checkbox to cell based on combo box choice

    I'll see what I can do for you

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Linking checkbox to cell based on combo box choice

    You've got a vba reference which is not on my system so I cannot help you.
    I'm not modifying my system for thsi.
    Have no Idea what the Microsoft Windows Controls does, probably a popup calendar or something like that since ms.Startdate throws the error.

+ 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. Autofill Colums based on combo box choice
    By Coleman34 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2014, 01:21 PM
  2. [SOLVED] Want to call Macro when cell changes as a result of Combo Box Choice
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2012, 09:26 PM
  3. Replies: 2
    Last Post: 07-10-2012, 04:37 PM
  4. Linking to Outlook Contact Information based on Combobox Choice
    By Nick_P in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2012, 02:28 PM
  5. Replies: 5
    Last Post: 01-05-2011, 11:37 PM
  6. [SOLVED] Exclusive choice checkbox
    By Tony in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-12-2006, 06:45 AM
  7. contents of 1 combo box depends on choice of another
    By Basheed Bazi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2005, 05:05 PM

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