Count Textboxes and other objects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dana - 10 Oct 2007 11:00 GMT

Is there any way that you can count the number of textboxes and other
drawing objects in a sheet using c# or VB from an application and change
their contents?

Reply to this Message

Joel - 10 Oct 2007 11:23 GMT

Dana: this code should work

Sub count_boxes()

Count = 0
For Each myshape In ActiveSheet.Shapes
If myshape.Type = msoTextBox Then
Count = Count + 1
End If
Next myshape

End Sub

> Is there any way that you can count the number of textboxes and other
> drawing objects in a sheet using c# or VB from an application and change
> their contents?

Reply to this Message

Rate this thread: