Good morning,

I am working on a calculation process that has various text boxes and combo boxes, and also creates an Excel session and opens the needed Excel file. So far, so good....

What I need to do is compare one of the text box values to a certain row/column on the spreadsheet.

Let's say, text1.Text = "200"

So, now while the Excel worksheet is open and running, it needs to locate where "200" is, by matching text1.Text to a certain row/column variable.

Example:
.....A..........B.........C..........D..........E
1...50........175......100.......75........125
2...60........120.......80........140......110
3...90........200......150.......70........115

Is this very difficult to do? I can get it to open up and display the Excel worksheet, but I don't understand how to compare a value from a text box to a certain row/column of a spreadsheet.

Thank you!

Butch A.