ArcObjects/VBA Import values from excel into a form

In short - is this possible?

I have an excel worksheet with the fields as rows, and a user inputs
values in the relevant columns and saves it.

I have created a form in ArcGIS - I would like to click the load
button, which prompts for location of spreadsheet, and then once
selected, it will pluck out the relevant cell-values from the
worksheet and dump them in the relevant text-boxes in the form.

I have not seen this done before with Excel. Any pointers would be
great.

Simon wrote:

In VB/VBA:
1) open your form
2) read the Excel file name
3) open it (google it... "VB excel open")
4) read the values ( value = cells(rowID,colID) )
5) write the values into your form

Jean