+ Reply to Thread
Results 1 to 5 of 5

Add CheckBox in Column A active Row

  1. #1
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Add CheckBox in Column A active Row

    I am trying to Add a checkbox in cell A in the active Row.

    The checkBox should take size after the cells size
    And have value off.
    I have a code but it does not seem to work.

    Any help will make my day :-)

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,400

    Re: Add CheckBox in Column A active Row

    .
    Your macro corrected :

    Please Login or Register  to view this content.

    To add more than one box in Col A :

    Please Login or Register  to view this content.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,400

    Re: Add CheckBox in Column A active Row

    .
    If you are relatively new to VBA programming, utilizing OPTION EXPLICIT at the top of your modules will assist. It oftentimes will highlight where your
    errors are in the code and give some insight how to correct.

    There is a setting in the EXCEL SETTINGS to turn on OPTION EXPLICIT so you don't have to manually type in the phrase every time.

  4. #4
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: Add CheckBox in Column A active Row

    Thanks Logit
    I needed it to add a checkbox in the active Row Column A

    I had a good nights sleep, and here is the solution.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,400

    Re: Add CheckBox in Column A active Row

    .
    Great ! Glad you have it solved.

+ 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] Make Worksheet Active-X CheckBox value same as Userform CheckBox value
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2016, 08:23 AM
  2. [SOLVED] Active X checkbox macro
    By TimlmiT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2014, 12:30 PM
  3. [SOLVED] change values of active x checkbox within VBA
    By tmallin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2014, 04:30 PM
  4. Questions regarding Active x Checkbox
    By behnam in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-20-2013, 01:27 AM
  5. making a timer from an active x checkbox
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2012, 01:02 PM
  6. Name of active checkbox
    By anteagles20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 03:10 PM
  7. Active Checkbox Value
    By t0m46 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2010, 05:56 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