I may have misunderstood your question, but I think you're looking for something BatchView already does: when you click in one of the fields that has the button with an underscore at the end (e.g. Batch ID, Product, Recipe, etc.), you can then click right on a cell on the spreadsheet. Clicking on the "underscore button" simply minimizes the window to let you pick a cell more easily - then you click on the underscore button again to restore the window to its original size.
For the the combobox-style fields (All, Active, Any Length, etc.), you need to click on that icon with the right arrow and this will turn the field into a "cell selection" field - this is when you can select a cell on the spreadsheet.
Let me know whether that's what you were looking for or I completely misunderstood you!
The user is not going to use the PI BatchView window hence the need of some code.
The reason to do this is to interact with the user with a simple interface and set a standard report for everyone.
As an example , the Start Batch Search button below will display the search results.
I hope this explains the problem. Thanks for your reply.
ahhhh, that explains why! Just wanted to make sure you knew BatchView supported referring to cells. Programmatically, you would could perform the same search BatchView performs using the following code:
Dim batches As PISDK.PIBatchList
Dim batch As PISDK.PIBatch
Set batches = somePIServer.PIBatchDB.PIBatchSearch(...) ' with arguments coming from the cells
For Each batch In batches
' do something with "batch"
(don't forget to add a reference to the PI SDK Type Library in your VBA project)
Hope this helps!