Resource List

[Matt_Chelmsford]

Afternoon everyone,

The challenge I have got is that I am trying to make a model where a user chooses from 90 resources (a bit like a shopping list) and what I want from this is just the chosen resources put into a simple list. So if the user chooses 3 items then the list will be 3 deep, etc.

I am thinking uder forms but my VBA is very limited.

I would appreciate any help given.

Matthew

 

[Jerry Sullivan]

Hi Matthew,

If your VBA skills are limited, consider using a worksheet based interface instead of a UserForm.

You could either list the items in cells, use data validation drop downs, or listboxes with multiple selection.

If your 90 items can be organized in categories, maybe dependent lists would be a good fit.