Results 1 to 9 of 9

Clear Contents and Checkboxes Button

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2013
    Location
    Virginia Beach, VA
    MS-Off Ver
    O365
    Posts
    19

    Clear Contents and Checkboxes Button

    Hello,

    I am trying to create a button in that will clear contents of E5:E8 and and also clear all checkboxes (located in D5:D8) on the sheet. I have the codes below but can't seem to get them to work together. Additionally, I cannot recall whether I created the checkboxes with activex or form.


    Private Sub CommandButton1_Click()
      Range("E5:E8").ClearContents
    Sub clearcheck()
     ActiveSheet.CheckBoxes.Value = False
    End Sub
    Last edited by chparkervatech; 06-21-2016 at 12:08 PM. Reason: To comply with forum rules

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to clear cell contents when another option button is clicked
    By doglovinlady in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2016, 05:31 PM
  2. Formula to temporarily clear contents of cell when button is clicked..?
    By jwd210 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2015, 01:42 AM
  3. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  4. How to clear contents/delete rows on click of button
    By murchy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2013, 09:11 AM
  5. Clear Contents Macro-a Command Button
    By Andy Small in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2009, 05:29 AM
  6. creating clear contents button
    By ttik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2008, 08:57 PM
  7. Clear cell contents with a button
    By KFC / A&W Boy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2005, 06:06 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