Generally speaking, you can do this with Range(<cell>).Value.
For example, to display a message box with the value of cell A1:
I need to read an Excel cell and provide the value in a PI display.
It probably would have been more helpful if you included this information in your original post. If you are trying to read data from an Excel sheet and save it to a PI Point, there are multiple options:
- Excel is compatible with ODBC drivers, so you could use ODBC to read from the sheet directly in ProcessBook via a dataset
- ODBC compatibility also means you could use PI RDBMS interface to read from the sheet
- Depending on the format of the sheet, PI UFL Interface is also another option
- Using VBA + PISDK, you could read the values, then write them to PI Points