How to copy value from excel cell and paste the value into a textbox in access form

[behnam]

Hi guys I have a spreadsheet with many values. How can I make certain cells of that spreadsheet equal to textbox's i have created in a access form.

[June7]

You want textboxes on form to be populated with values from Excel worksheet? Options:

1. set link to worksheet and use the link as RecordSource for form

2. VBA code to open worksheet object and pull values from specific cells