Thanks. I will try that out. "Andreas Saeger" <[email protected]> wrote in message news:[email protected]... > 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]
