Re: [libreoffice-users] List Box Form Control changing Source Cell Range
Sadly, I have always done this sort of thing using a Macro that is called when a new item is selected. On 08/20/2011 06:24 AM, Tom Davies wrote: Hi :) I'm sorry you have not had replies so far. I imagine there is a good answer so i split this question off into a new thread so that more people see it. Good luck and regards from Tom :) From: Jack Cambeljcna2000-dauntl...@yahoo.com To: users@global.libreoffice.orgusers@global.libreoffice.org Sent: Fri, 19 August, 2011 2:28:27 Subject: Re: [libreoffice-users] List Box Form Control changing Source Cell Range Hello, I want to make a list box (in Forms Control) affect the choices of another list box. Is there a function that allows me change ranges in the cells referenced in a List Box's source cell range? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] List Box Form Control changing Source Cell Range
Hi :) I'm sorry you have not had replies so far. I imagine there is a good answer so i split this question off into a new thread so that more people see it. Good luck and regards from Tom :) From: Jack Cambel jcna2000-dauntl...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 19 August, 2011 2:28:27 Subject: Re: [libreoffice-users] List Box Form Control changing Source Cell Range Hello, I want to make a list box (in Forms Control) affect the choices of another list box. Is there a function that allows me change ranges in the cells referenced in a List Box's source cell range? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] List Box Form Control changing Source Cell Range
2011/8/20 Tom Davies tomdavie...@yahoo.co.uk: Hi :) I'm sorry you have not had replies so far. I imagine there is a good answer so i split this question off into a new thread so that more people see it. Good luck and regards from Tom :) From: Jack Cambel jcna2000-dauntl...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Fri, 19 August, 2011 2:28:27 Subject: Re: [libreoffice-users] List Box Form Control changing Source Cell Range Hello, I want to make a list box (in Forms Control) affect the choices of another list box. Is there a function that allows me change ranges in the cells referenced in a List Box's source cell range? There was a thread like this a few days ago, and someone pointed out that a listbox maybe isn't the best way to go. He mentioned Data → Validation and gave links to example files. Try to search for that thread and you might have some luck. I'm on an EeePC right now away from home so I'd rather keep my typing to a minimum… I'll give a more precise reply when I get home if nobody else did. J.R. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] List Box Form Control changing Source Cell Range
Hello, I want to make a list box (in Forms Control) affect the choices of another list box. Is there a function that allows me change ranges in the cells referenced in a List Box's source cell range? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted