+ Reply to Thread
Results 1 to 5 of 5

Check mark behind the shapes

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

    Check mark behind the shapes

    Hello All,

    I am trying to put or insert a shape behind the check mark.
    See attachment of the sample sheet.

    Thanks.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Check mark behind the shapes

    It can't be done. The check mark is a character in cell text, and the box is a shape. Shapes are overlays on top of the grid. Shapes cannot go behind cell content.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

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

    Re: Check mark behind the shapes

    Oh ok. Thank you.
    What about if I add a images of box? Will still be the same?

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Check mark behind the shapes

    Not sure I understand what you mean by "images of box".

    I would just put a check mark as text right in the box, see attached.
    Attached Files Attached Files

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,256

    Re: Check mark behind the shapes

    Two other options...

    Resize cell into square and put a border around the cell containing the check...
    Place a square shape with no fill in cell...
    Attached Files Attached Files
    Last edited by sintek; 11-10-2022 at 08:32 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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] Changing Check Mark to X Mark vba
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-02-2022, 06:44 PM
  2. Only one check mark allows in a group of form control check box
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2021, 06:10 PM
  3. Change check box fill color to unfill and clear check mark
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2020, 03:20 PM
  4. Time in and out with Check mark to check out
    By aleross in forum Excel General
    Replies: 8
    Last Post: 10-02-2019, 07:50 PM
  5. [SOLVED] Help to check data with miltiple conditions then mark "YES" if meet else mark "NO"
    By sbv1986 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-05-2019, 05:52 AM
  6. Replies: 2
    Last Post: 10-28-2013, 03:52 PM
  7. Replies: 3
    Last Post: 04-13-2005, 05:52 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