On Sat, 2005-04-16 at 13:47 -0500, Peter Kupfer OOo wrote: > Leslye Olsen wrote: > > Hello. Thanks in advance for any help you may offer. > > > > My issue: I would like to create a drop down menu in a cell in a > > spreadsheet, with a list of names or numbers as a "database". In MS > > Excel, I can link a range of cells in another spreadsheet, and the > > dropdown menu points to it. > > > > I am using OpenOffice 1.1.1 on SuSE 9.1 Personal, from the live CD > > install. (i386 machine...) > > > > I hope that this question is understandable and someone has some > > answers. Thanks again... > > > > Ruel Olsen > > [EMAIL PROTECTED] > > > Try AutoFilter.
When you add the control, you have the option of using a range of cells as the "database" input. This means that you can define all your "menus" on a hidden sheet, and have the control reference them and update to the linked cell that you define. This is much easier than trying to define event listeners and macros. 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]
