Hi

I am (or thought I was!) a reasonably competent Excel user, but I am having trouble with comboboxes on a form I'm creating, which will be used for data input by end users. Previously, I would have used Access for this purpose but as my current employers don't use Access, I am having to make the form in Excel. The form is 99% complete and usable as it is, but I would like to make one final update for ease of use.

Basically, I'm trying to find a way of replicating Excel's "indirect" function in a combobox, so the selections from a second combobox are dependent on the input in the first one.

To explain, the user selects an item from the first box - let's say the first box contains the options "Boys Toys", "Girls Toys" (not my choice - I think anyone can play with any toy), "Games" and "Radio Control". The second combobox contains the options "Barbie", "Horrible Science", "1:24 Scale Ferrari", "Monster High", "Scooter" and "Playmobil". Some of those toys fit in more than one category (eg Scooter could be "Girls Toys" or "Boys Toys", but some are specific - eg "1:24 Scale Ferrari" would only be in "Radio Control" (okay, we could argue the point about "Boys Toys" but that's not really relevant!) and "Barbie" would be in "Girls Toys". I have named ranges for each of the categories. My aim is to only allow the relevant selections in the second combobox dependent on the first selection, which I thought would be done using a Case statement, but either I'm wrong, or my syntax is wrong.

Any help would be very much appreciated, an apologies if this has already been answered previously - I did try to search the forums but couldn't find anything matching.