+ Reply to Thread
Results 1 to 16 of 16

Check mark box

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Check mark box

    Hello,
    I inserted a box images in the worksheet and I want that when I click the box images then it will have a bolded check mark in it in the cell is B6, B10 and B14. Please see attached worksheet.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Check mark box

    Here is a version that works by swapping boxes in and out based on their names.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    HI
    When I open the attachment you sent, I received few errors.
    "Can't execute code in a break mode" and also "run time error - specified value is out of range" that when I click the box in sheet1.

    Thanks.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Check mark box

    Did you change the name of the BOXES sheet by any chance or the names of the boxes?

    The boxes have specific names: Ref_Off_Box, Ref_On_Box, Sur_Off_Box ... OTH_On_Box. These are swapped out with Off_Box and On_Box on the Boxes sheet.

    At any rate, I cannot duplicate the error.

  5. #5
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Check mark box

    Here is a version that uses Wingding fonts and piggybacks onto your cell selection change event.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    Hi
    No, i just opened the worksheet u sent as an attchment and that when i get those errors.
    Tnx

  7. #7
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Check mark box

    I just downloaded the file I sent in the prior post in case I attached the wrong file or it got corrupted in the upload. It still works here. Hmmm. Can you try it on another machine?

    About the only thing I can see different is that you have 2010 and I have 2016, but I don't think I've used any version specific code.

    Can you include a screen shot that shows the line in the VB editor that is causing the issue? There are a couple of places where this error COULD occur. I'd like to concentrate on the specific item.

  8. #8
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    Hi,
    I like this and it work on my computer when I click the boxes.
    The only problem is that when I protected the sheet it does not work. I really need to have the worksheet be protected and still be able to click the boxes.

    See attachment.
    Thanks.

  9. #9
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    here is the attachment.

  10. #10
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    Hi,
    I tried to attach the file twice but it looks like its not going through.
    Do you see them?

  11. #11
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Check mark box

    Well, you did not mention protecting the sheet (or I didn't catch it) . I added in a line of code that allows the code to be executed but still keeps the sheet protected as far as the user is concerned.
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    :O)
    Good morning
    Sorry....:o(

    I received an error run time when I clicked the box while the worksheet is protected. See attachment.
    Also, please... if you can instead of "x" mark, is there a way you can make it as a check mark? if not "X" is ok.

    Thanks
    Attached Files Attached Files

  13. #13
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Check mark box

    This one has me stumped. If I take the version you posted and run it, I get an error when it runs because it tries to change the name of the shape ONLY when it is locked - I know what is happening, I don't have a clue as to why.

    The version I post here works fine. I compared the two files side-by-side. They are identical as far as I can see except for file size. Yours is 434K mine is 170K. So obviously yours has something mine does not. Are you making any modifications to the file I sent you before running it?
    Attached Files Attached Files

  14. #14
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Check mark box

    P.S. as for the check box.

    The box with the X is the best I could do on short notice. I had to take your box, superimpose the "X" on it, group it and then save it as a merged graphic. I could not find any readily-available clip art to suit my purpose.

    If you want to change the appearance of the boxes, find suitable blank and checked boxes and save them as images on the Boxes sheet. Remove the existing boxes. Name the blank box Off_Box and name the checked box as On_Box.

  15. #15
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    Hi,
    Answer to your question....Are you making any modifications to the file I sent you before running it? No.

    The X is fine :o)

    I will try the one you recently sent. I'll let you know.
    Thanks.

  16. #16
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,142

    Re: Check mark box

    Hi,
    I just opened the attachment you just recently sent and still get the same error.

    Thanks.

+ 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. [SOLVED] Add check mark(s) to range B6:F11.
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2016, 05:59 PM
  2. Replies: 2
    Last Post: 10-28-2013, 03:52 PM
  3. I can't find check mark
    By TToye in forum Excel General
    Replies: 2
    Last Post: 08-20-2012, 04:10 AM
  4. Check Mark?
    By geneg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2009, 04:19 AM
  5. [SOLVED] Check Mark
    By Anthony Viscomi in forum Excel General
    Replies: 7
    Last Post: 02-02-2006, 12:30 PM
  6. Replies: 3
    Last Post: 04-13-2005, 05:52 PM
  7. [SOLVED] check-mark symbol
    By Shooter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2005, 10:06 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.08251 seconds
  • Memory Usage 9,307KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (16)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (6)postbit_attachment
  • (16)postbit_legacy
  • (16)postbit_onlinestatus
  • (16)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1