Loop through Excel Textboxes from Access

[Ziggurat]

Hi All

Does anyone know how I can loop through all the textboxes on a worksheet in an excel workbook ?

I have used CreateObject to get the Excel application. I have set the workbook and the worksheet but I don't know how to loop through the textboxes.

Any ideas ??

Thanks in advance.



#
###
#####
#######
Ziggurat

 

[TonyJollans]

Hi Ziggurat,

Textboxes are part of a Sheet's OLEObjects Collection, so something like this should get them ..

[blue]

For Each xlObject in xlWorkSheet.OLEObjects
    If TypeName(xlObject.Object) = "TextBox" Then

[green]

' Do whatever

[/green]

    End If
Next

[/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.