| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.interopoledde,microsoft.public.excel.programming,microsoft.public.excel.sdk
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming,microsoft.public.excel.sdk,microsoft.public.excel
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count the unrepeated objects on a excel list | Excel Discussion (Misc queries) | |||
| Excel VBA Class Objects - Parent & Successor Objects | Excel Programming | |||
| Count number of textboxes | Excel Programming | |||
| Count selected Objects | Excel Programming | |||
| Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming | |||
![Dana[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
