One way is to use a listbox one row high, with a RowSourceType of
Table/Query and a RowSource like this (adjusted for the workbook,
worksheet and cell address:
SELECT F1
FROM [Excel 8.0;HDR=No;database=D:\folder\file.xls;].[Sheet1$B5:B5];
You may be in the wrong Newsgroup! Are you trying to display the value
of an Excel worksheet Cell in an _Access_ Form. If so, you will either
need to link to the spreadsheet as a Table or use Office Automation to
open the spreadsheet and get the cell value. If not, try asking again
in an Excel group.
Hi all,
How can I display the value of a specific Excel worksheet
cell in a form?
