MrExcel Publishing
Your One Stop for Excel Tips & Solutions

OLE to Excel

Posted by Mark on April 19, 2000 7:16 AM

I have an excel spreadsheet that has textboxes in it and want to get the names of those textboxes from a PowerBuilder Ole session. Is there an excel method that returns the names of all textboxes in the spreadsheet?

Posted by Ivan Moala on April 20, 2000 12:56 PM

Hi Mark
have a look @ the sheets shapes collection.
eg Sub TxtBoxName()
Dim TB
Dim Nm as string

For Each TB In ActiveSheet.Shapes
Nm = TB.Name
End Sub