Count Textboxes and other objects   

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?

date: Wed, 10 Oct 2007 11:01:16 +0100   author:   Dana

RE: Count Textboxes and other objects   

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

"Dana" wrote:

> 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?
> 
> 
> 
> 
> 
>

date: Wed, 10 Oct 2007 03:23:00 -0700   author:   Joel