+ Reply to Thread
Results 1 to 2 of 2

Form with 4 checkbox

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    Philippines, Manila
    MS-Off Ver
    Excel 2010
    Posts
    140

    Form with 4 checkbox

    Hi Everyone,

    I need your help.

    I have 4 checkboxes, each have corresponding title ex.

    Checkbox1 = Boy1
    Checkbox2 = Boy2
    Checkbox3 = Boy3
    Checkbox4 = Boy4

    If the checkbox is True, then in should be put in ONE CELL (A1). Now, because I have 4 and all have to be under ONE cell, I don't know what to do.

    Example: if CheckBox2 and 3 were TRUE, then the answer should be
    Boy2 Boy3

    Example: if CheckBox1,3 and 4 were TRUE, then the answer should be
    Boy1 Boy3 Boy4

    Is it possible?

    Thank you in advance,

    ^_^

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Form with 4 checkbox

    which checkbox are you using?
    is it in a Userform, ActiveX or FORM control?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Protect the sheet but the form checkbox still can be change and sort by checkbox
    By carolyn1221 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2014, 01:08 PM
  2. [SOLVED] Form Control Checkbox
    By hhpack3 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-11-2014, 04:43 PM
  3. Trying to scale a form checkbox in a macro, don't know how to get checkbox name
    By tstruch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2014, 12:14 AM
  4. Replies: 2
    Last Post: 03-19-2013, 08:01 AM
  5. help on checkbox form
    By albert28 in forum Excel General
    Replies: 3
    Last Post: 06-04-2010, 09:11 AM
  6. Checkbox on form won't uncheck
    By beckstei in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2007, 01:55 PM
  7. checkbox on form reset from checkbox on sheet
    By raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2005, 01:15 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