+ Reply to Thread
Results 1 to 9 of 9

Controlling Multiple Checkbox Position

  1. #1
    Registered User
    Join Date
    05-13-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Controlling Multiple Checkbox Position

    Hi all,

    I'm using the following code to add multiple checkbox to my spreadsheet for each cell in column A. I have 584 check boxes in total, and need them to lineup with the row#, however the checkboxes don't align themselves correctly in the center for each cell / row (see attached snip). Is there a code to force the cbx into the middle center of each cell in column A? I've tried changing the width height, but cannot get everything centered and lined correctly.

    Please Login or Register  to view this content.
    Any help would be much appreciated.
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Controlling Multiple Checkbox Position

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you as you haven't been around for a while. Please read new forum rules to refresh your memory

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Controlling Multiple Checkbox Position

    This happens if your row height is set smaller than the minimum checkbox height.

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Controlling Multiple Checkbox Position

    From the depths of my archive.
    Routine to centre position Sheet Checkboxes and ActiveX checkboxes.
    Adapt code to suit, this may cure your problem.
    torachan.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-13-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Controlling Multiple Checkbox Position

    Apologies Pepe, i will remember for next time! Thank you.

  6. #6
    Registered User
    Join Date
    05-13-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Controlling Multiple Checkbox Position

    Thank you torachan, that worked a treat!

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Controlling Multiple Checkbox Position

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Controlling Multiple Checkbox Position

    Quote Originally Posted by cmturner20 View Post
    Apologies Pepe, i will remember for next time! Thank you.
    No worries

  9. #9
    Registered User
    Join Date
    11-22-2019
    Location
    texas
    MS-Off Ver
    2013
    Posts
    9

    Re: Controlling Multiple Checkbox Position

    Thanks for your response.

+ 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. Position of a checkbox
    By carlos1980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2019, 06:41 AM
  2. Replies: 1
    Last Post: 10-05-2016, 12:45 AM
  3. Controlling Image position through VBA
    By KamranMustafa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2016, 11:28 AM
  4. Replies: 1
    Last Post: 07-27-2014, 10:57 AM
  5. Controlling shape position using VBA
    By roey b in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-14-2014, 04:04 AM
  6. Controlling display position
    By barryleajo in forum Excel General
    Replies: 5
    Last Post: 07-22-2010, 02:13 PM
  7. Controlling Cursors position in Excel
    By rsk_beckon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2009, 10:28 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