Mathias Bauer wrote:
TerryJ wrote:
Someone has asked about this in the forum and I believe there is no
provision in the API for this. I used such code with another
spreadsheet and the person enquiring now has used similar code with
other software.
An example of its use would be to have the script navigate to various
locations in the spreadsheet and pause for input by the user at each
location.
It occurs to me that an issue could be filed requesting such a feature.
Is there already a method in the API which can be used to write such a
routine?
Waiting is bad - it creates a loop that can cause reentrance problems.
It's better to end macro execution and install a listener for an event
to be triggered by user input. Perhaps if you described what kind of
user input you are talking about we could find out which listener is
possible.
Ciao,
Mathias
Thank you for the reply. I was hoping for a solution suitable for more
general use.
Typically, some data is typed and the ENTER (return) key is used to
place it in the cell.
The ENTER key will be used each time data is entered but the desired
result is that the cell pointer would then move to the next location in
the series, not to the same location each time.
I suppose you would need to install and remove the listener on each
occasion. {?} was so much simpler and seemed to have no undesirable
results - no loops and no difficulty proceeding. It was in use for many
years in Lotus 123 and, evidently, in QuattroPro, so there was nothing
shonky about it.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
