Karti wrote:
Please help me out with this.
"Karti" <[email protected]> wrote in message
news:[email protected]...
Hi,
It is possible to use named range in the "source cell range" while
creating the listbox/combo box?
If it is not possible is it possible to use a formula in the "source cell
range".
I would like to use the following formula:
OFFSET($Database.$A$1;3;0;COUNTA(OFFSET($Database.$A$1;3;0;50;1));19) to
get the data into the list box.
Thanks.
Hi Kati,
List boxes are best used with database forms. In spreadsheets they make
not much sense. Cell validation (Data>Validity...) by range supports all
types of formula expressions, such as named references and since version
2.3 calculated references as well.
Example:
http://user.services.openoffice.org/en/forum/download/file.php?id=333
Have fun,
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
