Hi,
If you write in StarBasic you may have a look at function
InputBox(msg,title,default,x,y). It returns an empty string on cancel,
which may be handled with a msgbox (skip,cancel,repeat?).
You may use the returned value for setting property FormulaLocal of the
cell in question. Setting a cell's FormulaLocal is more or less like
typing the string into the cell, including date/time-conversion,
TRUE/FALSE, localized function-names and so on.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]