+ Reply to Thread
Results 1 to 2 of 2

Position of a checkbox

  1. #1
    Registered User
    Join Date
    04-29-2019
    Location
    Hampshire, England
    MS-Off Ver
    2018
    Posts
    43

    Position of a checkbox

    I am using the below code to produce a checkbox automatically when a row is completed but as more and more rows are added the checkbox in the cell positions further and further down in the cell as you go down the sheet, eventually crossing over into the next cell. Is there a way to fix the position within a cell for the checkbox to appear and sit?

    Please Login or Register  to view this content.

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

    Re: Position of a checkbox

    See if the attached is adaptable to your needs.
    Usable with both Form checkbox on sheet & normal on sheet checkbox.
    The size of the checkbox has to be smaller than the cell, if it overlaps cell borders everything gets confused.
    torachan.
    Attached Files Attached Files

+ 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. Dynamic userform position based on widow position
    By Manish84 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2015, 07:47 AM
  2. [SOLVED] Checkbox position changes as the worksheet zoom changes
    By Bob1980 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-11-2014, 02:53 PM
  3. Replies: 1
    Last Post: 07-27-2014, 10:57 AM
  4. Replies: 1
    Last Post: 06-22-2012, 08:59 PM
  5. check checkbox value by position
    By grendel_42 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-21-2010, 09:04 AM
  6. check checkbox value by position
    By grendel_42 in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2010, 05:17 AM
  7. Access a cell based on CheckBox position
    By franferns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2009, 09:40 AM

Tags for this Thread

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