Macro to select an item from a data validation list

Hi,

I need a macro that will essentially "open up" a data validation list and select one of the items.

I have heard that combo-boxes work for this sort of thing, but I would really like to use Data validation because that is commonly used at my company and combo-boxes may present unknown issues.

help?

thanks!!

Oh sorry, I just mean that I want the macro to select one of the items listed in the validation list. Open up >> click the data validation's down arrow and select one of the items.

perhaps it would be better for me to explain my situation a bit.

The purpose of the spreadsheet is to track part numbers for a list of parts within a unit. I have 3 different unit configurations, each with 30 or so unique part numbers (**some parts are interchangeable between units, this is important later). I have a macro that populates my form with the 30 part numbers for the particular unit using a user selected unit from data validation list.

So here's what I want the form to do:

A user will select a unit from the data validation list, a macro (the one I have already created) will populate the form with 30 part numbers.

Those 30 part numbers will each be their own data validation list, so the user can select between 3 different parts if the unit has a non-standard configuration.


My thought was to have my macro copy 30 data validation lists that are already setup, and select the appropriate part for the unit. So depending on which unit the user selects, there will be 30 validations lists that get populated into the form with the appropriate parts.

ugh, does that make sense?

Yep. I deleted some stuff, so hopefully it still makes sense. I dont have any code in it right now, but the basic concept is this:

select a configuration, use data validation list + macro to populate part numbers (using listed part numbers below), but each part number field will still have a user editable field with the 3 listed options after configuration is selected.

Leith,

is there any chance you have input for me here?

thanks!