Vlookup on embedded excel sheet in access form

[mudstuffin]

Hello.

I have a form (Form1) in an access 97 db, and I have embedded an excel sheet in the form (OLEUnbound14).

In the sheet I have a range of data (DRangeNames)

I want to be able to perform a vlookup on the data range to look for the string "greg" for example, or the contents of the text0 textbox contents...?

How do I do this in VBA in my access form...?

Thanks.

mudstuffin

 

[mudstuffin]

Anyone got any suggestions..?