Multi Colum Listbox in UserForm
Hello all you clever people!
Been having some success with listboxes to collect data on Userforms, but what I would like to try and do now is have a multi colum listbox, ie I have the main selection of a "Business Unit" which depending on the choice made will offer up a list of "Business Area", again depending on the choice made here then a list of "Departments" to be shown. Is it possible to do this, can anyone point me in the right direction? -- Zani (if I have posted here, I really am stuck!) |
Multi Colum Listbox in UserForm
That's not a multi-column listbox, but a multi, dependent listboxes.
Best way is to have an initial Business Unit list on a worksheet and bind Listbox1 to that, and have a list for all options, named appropriately, for example BUs Sales Finance HR etc. and then have lists for each, such as Sales Corporate Retail Internal etc, and use a named range, say bu_Sales for this. Create the other lists as well, then in the code, when a selection is made in Listbox1 Listbox2.RowSource = Range("bu_" & Listbox1.Value).Address(,,,True) which will load Listbox2 with the appropriate data. Do the same for the Business Areas. -- HTH RP (remove nothere from the email address if mailing direct) "Zani" wrote in message ... Hello all you clever people! Been having some success with listboxes to collect data on Userforms, but what I would like to try and do now is have a multi colum listbox, ie I have the main selection of a "Business Unit" which depending on the choice made will offer up a list of "Business Area", again depending on the choice made here then a list of "Departments" to be shown. Is it possible to do this, can anyone point me in the right direction? -- Zani (if I have posted here, I really am stuck!) |
Multi Colum Listbox in UserForm
Thanks Bob you are a star! That is exactly what I needed, and it all seems
so simple now! -- Zani (if I have posted here, I really am stuck!) "Bob Phillips" wrote: That's not a multi-column listbox, but a multi, dependent listboxes. Best way is to have an initial Business Unit list on a worksheet and bind Listbox1 to that, and have a list for all options, named appropriately, for example BUs Sales Finance HR etc. and then have lists for each, such as Sales Corporate Retail Internal etc, and use a named range, say bu_Sales for this. Create the other lists as well, then in the code, when a selection is made in Listbox1 Listbox2.RowSource = Range("bu_" & Listbox1.Value).Address(,,,True) which will load Listbox2 with the appropriate data. Do the same for the Business Areas. -- HTH RP (remove nothere from the email address if mailing direct) "Zani" wrote in message ... Hello all you clever people! Been having some success with listboxes to collect data on Userforms, but what I would like to try and do now is have a multi colum listbox, ie I have the main selection of a "Business Unit" which depending on the choice made will offer up a list of "Business Area", again depending on the choice made here then a list of "Departments" to be shown. Is it possible to do this, can anyone point me in the right direction? -- Zani (if I have posted here, I really am stuck!) |
All times are GMT +1. The time now is 10:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com