Sorry if this is in the wrong forum but I think this is the most appropriate one. I have a couple of drop down menu's on a sheet (not on a userform), my problem is I want them to be selected in a set order, is there any way I can check that a previous menu has been selected before allowing the user to move onto selecting the next menu? The menu's all have to be on the same sheet, so I can't use one menu per sheet or form or something like that. Also, I want the second and third menu to have options only relating to the option that is selected in the first menu. eg-if the first menu was labelled "processor" and the user selected Athlon XP, then the second menu (labelled motherboards) would only show motherboards that support AMD processor's. How do I go about doing this? I was thinking of having a column next to the processor and motherboards (which will be in a seperate sheet) with the title "format". So for a AMD processor you could put socket A, and this would be the same for the motherboard format column, this could be used to filter out the options...am I on the right track here? Please tell me if you don't get what I mean and I'll upload the sheet to show you what I mean.

Apologies for not helping solve your specific Excel issue - (though if I get what you are trying to do, I would suggest you have a macro repopulate the second and third menus on specific actions on the first and second, which may not be the best answer) - but wouldn't this be FAR easier in Access? Tom

I do think it would be a lot easier to do in Access but I can only use Excel to solve the problem. Either that or link Access into Excel, but if i was going to do that I may as well use Access to do the rest of the problem.

OK - I've built you an example spreadsheet. Post your email address and I'll send it to you - its a bit difficult to explain here. Tom (feeling charitable because he has a blistering hangover)

sorry - just realised you have! (Told you I was hungover) It should be with you in about five minutes...

And yet, as my hangover deepens, I realise that its a rubbish address! Any chance you can post your real one? Or if you don't want to do that, then quickly set-up a Hotmail account and post that instead. Tom

Sorry about that, I thought you might have to enter a email address in order to post a message. my real email address is with this message. Thanks for the help as well, I appreciate it. Have you recovered from that hangover yet? :)