On Tue, 2005-08-02 at 06:34 +0200, Chadley Wilson wrote: > Greetings > > I was wondering, I would like to restrict the contents of the cells in a > specific column. > > Let me explain, in my case for column P, the user must only be able to type > in > branch codes, the branch codes must be predefined through a drop down list. > > The reason is that I will be using countif combined with sum to calculate the > totals that we have produced for our branches. > Could someone please tell me what we call this and if possible provide and > example of how to set it up?
Hi Chadley, This is quite simple in the newer 1.9 (2.0 beta) series of OpenOffice.org. Simply go to Data -> Validity and choose the list criteria. Specify your required branch codes and the column is set. If you are using 1.x series, then to use Validity in a similar way, you will have to trap all entries and then do it through a macro event handler. Regards Jonathon -- OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase - http://mindmeld.cybersite.com.au/ Cybersite Consulting - http://www.cybersite.com.au/ Training4Linux - http://www.training4linux.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
