Multiple ListBox Change

[subtilty]

Hi All,

I have several pages with about 80-100 Listboxs on as they are used to pick what vehicles each ticket corresponds to.

I need to update the list of all of the listboxs to add some more vehicles, is there a way using VBA to amend all the ListBox's on a sheet to point to different list selection?

Many Thanks,
James

[Norie]

How are they currently being populated?

[subtilty]

They are being selected by the user clicking the relevant vehicles and then saving the sheet and sending it to me.

I understand I cannot change the order of the listed items as where they have clicked would change, I just want to add some more to the bottom of the list.

[Norie]

What I meant was how are the listboxes being populated with values?

Are you using a range?

Perhaps there's code that does it.

[subtilty]

All of listboxes are being populated with an Input Range. I wish to change the Input Range, on all of the listbox

[Norie]

Can you attach a sample workbook so we can see what you have?

[subtilty]

Hi, here is a small sample attached.

[Norie]

James

Create a (dynamic) named range called VehicleList that refers to this formula:

Please Login or Register  to view this content.

Then run this code to update all the listboxes on Summary to take their list from the named range.

Please Login or Register  to view this content.

Now whenever you add (or delete) vehicles from the list the listboxes will update accordingly.

[subtilty]

Hi Norie,

I do not understand the first part..

I have pasted the formula into a cell and defined its name to VehicleList but then it just gives to listbox a list of 1 vehicle.

James

[Norie]

James

On the Formulas ribbon goto Name Manager.

If VehicleList is already listed in the Name Manager delete it.

Then click New...

For Name enter VehicleList and for Refers to enter this formula.

Please Login or Register  to view this content.

Then press OK.