Results 1 to 11 of 11

Clear Checkboxes macro

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2016
    Location
    Oregon
    MS-Off Ver
    2016
    Posts
    8

    Clear Checkboxes macro

    I have the following macro and need to insert a command where ******* is to clear the checkboxes that are on sheet "ExpenseEnter". I don't know how to write this part of the code.


    Sheets("Launch").Select
        Sheets("TimeEnter").Visible = True
        Application.Goto Reference:="ClearTime"
        Selection.ClearContents
        Sheets("TimeEnter").Select
        Sheets("MilesEnter").Visible = True
        Application.Goto Reference:="ClearMiles"
        Selection.ClearContents
        Sheets("ExpenseEnter").Visble= True
        Application.Goto Reference:="ClearExpense"
        Selection.ClearContents
        Sheets("ExpenseEnter").Select
       
     *******
    
        Sheets("MilesEnter").Select
        ActiveWindow.SelectedSheets.Visible = False
        Sheets("TimeEnter").Select
        ActiveWindow.SelectedSheets.Visible = False
        Sheet("ExpenseEnter").Select
        ActiveWindow.SelectedSheets.Visible = False
        End Sub
    Last edited by alansidman; 07-26-2016 at 08:42 PM. Reason: code tags added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I combine a simple "clear" macro with another that clears checkboxes?
    By Maezee in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-22-2013, 01:30 PM
  2. [SOLVED] Clear multiple checkboxes
    By mfortier3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2013, 12:27 PM
  3. Clear all checkboxes
    By bjohnsonac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2011, 06:12 PM
  4. [SOLVED] Sheet Checkboxes clear
    By Pete in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2005, 04:05 AM
  5. Replies: 5
    Last Post: 07-29-2005, 08:05 PM
  6. how do i create a macro to clear checkboxes and display a message.
    By Xavierskyrider in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-25-2005, 06:06 PM
  7. Clear All Checkboxes?
    By Brad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2005, 04:06 PM

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