+ Reply to Thread
Results 1 to 4 of 4

macro remove if mark in checkbox

  1. 03-02-2016, 05:04 AM #1
    MetteGaga
    MetteGaga is offline
    Forum Contributor
    Join Date
    10-23-2014
    Location
    Kolding, Denmark
    MS-Off Ver
    MS Office 2010
    Posts
    169

    macro remove if mark in checkbox

    hi,

    i have made a workbook with a lot of checkboxes made in the developer tab.
    Can i make a macro to remove if the box has a mark in it ?
    Reply With QuoteRegister To Reply
  2. 03-02-2016, 06:49 AM #2
    danny2000
    danny2000 is offline
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    176

    Re: macro remove if mark in checkbox

    Hello

    I'm not sure if you mean you have made checkboxe's in the developer tab of the workbook or in a userform covered in checkboxe's. I've provided an examples below. I have tried to upload spreadsheets but I can't . Will keep trying.

    Just keep in mind that if you are using the Excel Spreadsheet covered in checkboxe's option, those checkbox's have to be ActiveX controls not form controls. There's a difference, and this macro will not recognize the form control version.

    (5 minutes later..... The spreadsheet is attached).

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by danny2000; 03-02-2016 at 06:56 AM.
    Reply With QuoteRegister To Reply
  3. 03-03-2016, 04:49 AM #3
    MetteGaga
    MetteGaga is offline
    Forum Contributor
    Join Date
    10-23-2014
    Location
    Kolding, Denmark
    MS-Off Ver
    MS Office 2010
    Posts
    169

    Re: macro remove if mark in checkbox

    i have a question to your macro.. It delete the hole checkbox, i only want it to remove the checkmark..
    Reply With QuoteRegister To Reply
  4. 03-03-2016, 05:19 AM #4
    danny2000
    danny2000 is offline
    Forum Contributor
    Join Date
    09-23-2007
    Location
    Melbourne, Australia
    Posts
    176

    Re: macro remove if mark in checkbox

    haha.. I thought you wanted to checkbox to disappear

    See attached.prac_mac.xlsm


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it possbile to remove a macro and/or checkbox when a spreadsheet is copied?
    By Erik63 in forum Excel General
    Replies: 0
    Last Post: 11-20-2014, 03:04 PM
  2. Using cell as checkbox (add tick mark)
    By ThePixie in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-05-2013, 12:02 AM
  3. VBA to IE mark a checkbox (name/element issue)
    By Fargus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 01:42 PM
  4. how to remove quote mark on an address formula
    By ratjhman in forum Excel General
    Replies: 3
    Last Post: 02-23-2011, 11:24 PM
  5. Remove small question mark in CSV file
    By naflas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2010, 10:39 PM
  6. Mark checkbox if cell has certain value
    By laticca8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2008, 12:34 PM
  7. How To Remove Page 1 Water Mark?
    By travelersway in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-27-2005, 03:57 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1