problem with spreadsheet in vb

[burndailer]

Helo everyone,

At this moment i'm working on a program in vb6.
I have intergrated a spreadsheet in my programme.
I have made a textbox , where i can type what i want to search in the xml_spreadsheet and when i push the button "search", he must display me the found text in the spreadsheet.
I have made sutch example in excel in a macro, there was no problem.
I dont know what code i must juse to search in the spreadsheet.
Could annyone help me please ,i tryed everything.
Please in a code example, so i can understand it better, because i'm from holland and my english is not verry well.
Thanks.

i'm not comming further then this:

Private Sub Zoeken_Click()
Spreadsheet1.Cells.Find(What:=(Form1.Text2.Text)).Activate
End Sub
And this gives a error!!

[RobDog888]

What is the error your getting?