Results 1 to 7 of 7

Speed up the macro coding

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    135

    Speed up the macro coding

    Hi All,

    Any one help me to fix the below mentioned macro to accelerate his speed, in that sheet contains more then 35 check boxes. If am select the "Select All" Option it will take a minute to select all the check boxes. so i need to fix that issue. Seeking your comments on this.

    Sub Check_Box()
    Application.Calculation = xlCalculationManual
            Application.ScreenUpdating = False
                    If Sheets("Filters").Shapes("Check Box 42").ControlFormat.Value = 1 Then
                    		For i = 43 To 76
                    Sheets("Filters").Shapes("Check Box " & i).ControlFormat.Value = True
                    		Next i
        Else
                    		For i = 43 To 76
                    Sheets("Filters").Shapes("Check Box " & i).ControlFormat.Value = False
            			Next i
                    End If
    Application.Calculation = xlCalculationAutomatic
    End Sub


    Thanks/Raju
    Last edited by rajuganapathy; 06-30-2019 at 09:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to avoid cell SELECTION but still format cells to speed up the macro running speed
    By BeefyBerts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2018, 08:18 AM
  2. Everage Speed km/time (european speed)
    By GerryZucca in forum Excel General
    Replies: 3
    Last Post: 02-23-2015, 03:02 PM
  3. How to make VBA offset and speed up coding
    By Toyo613 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-05-2014, 10:34 AM
  4. macro coding help (i have no background in coding)
    By notgoodenough in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2014, 10:22 PM
  5. [SOLVED] Vb macro coding for transpose - complete coding?
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-02-2013, 11:16 PM
  6. [SOLVED] Vb macro coding for transpose - complete coding?
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2013, 05:04 AM
  7. [SOLVED] Implant macro coding into ASP coding
    By Sam yong in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2005, 06:05 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