Form Type Progress Indicator Requested.

Didact

New Member
Joined
Jul 16, 2013
Messages
1
Form type progress indicator requested. Could anyone code a progress indicator into the following (I'm having a heck of a time trying to decipher VB):

Code:
Sub addComments()

    ' first we'll clear existing comments
    For Each cmnt In ActiveSheet.UsedRange.Cells
        cmnt.ClearComments
    Next
    ' add a comment to cells that have something in them
    For Each cell In ActiveSheet.UsedRange.Cells
        ' add a comment with current cells
        cell.AddComment cell.Text
    Next

    ' now we will change the size of the font
    For Each cmmnt In ActiveSheet.Comments
        With cmmnt.Shape
            .TextFrame.AutoSize = True
            .AutoShapeType = msoShapeRectangle
            With .TextFrame.Characters.Font
                .Size = 11
            End With
        End With
    Next cmmnt
End Sub

-Ricardo (Technical Analyst)
Excel 2010
Excel 2013
Windows 7
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,215,067
Messages
6,122,949
Members
449,095
Latest member
nmaske

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top