+ Reply to Thread
Results 1 to 6 of 6

Question on CheckBoxes

  1. #1
    Forum Contributor
    Join Date
    05-14-2007
    Posts
    117

    Question on CheckBoxes

    I Have a problem with an options sheet that has a lot of tick box options. Im wondering if anyone can show me how to data validate a section of tick boxes so if the user trys to move on to another set of boxes a warning appears to say a previous field is not complete.Is this even possible?

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Your title is misleading, you are not asking about Data validation, but CheckBoxes. Can you say which type you are using - from the Forms toolbar or Controls toolbox.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    05-14-2007
    Posts
    117
    Hi Royuk

    Sorry about that, I dont know much about validation, the checkboxs were added to my worksheet by someone else from the forum who helped me before, I now know how to do them, just not sure how you tell where they come from, will that make a difference from the way they were created to what I need to do? Ive added an example, If you can help,it would be much appreciated

    Regards

    jamie.c
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    05-14-2007
    Posts
    117
    Can anyone help me, or can anyone tell me if im wanting to do something that simply can not be done?

  5. #5
    Forum Contributor colofnature's Avatar
    Join Date
    05-11-2006
    Location
    -
    MS-Off Ver
    -
    Posts
    301
    Easiest way to do it would be:
    1. In the hidden column (C), after each of the groups add an =OR() formula to determine if any of the checkboxes in that group have been selected.
    2. Assign a macro to the checkboxes in each group to dtermine if the OR formala is true or false and display a message accordingly.

    So for the "Additional Sockets" group, unhide column C and insert in C6 the formula "=OR(C3:C5)". Then open the VB editor and add this code:
    Please Login or Register  to view this content.
    then go back to your spreadsheet and right click on each of the checkboxes in the group in turn, selecting "Assign Macro..." then picking "additional_sockets_click" from the list. Repeat for the other groups, adding altered code for each.


    Col
    If you give someone a program, you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime.

  6. #6
    Forum Contributor
    Join Date
    05-14-2007
    Posts
    117
    Hi Col,

    Thats perfect!!! thank you so much

    Regards

    jamie.c

+ 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