Cascading Combo Boxes

[SASHA_D]

Hi Everyone,

I know this is an access forum, however I was wondering if anybody knows how to create cascading or linked combo boxes in excel?
I.e. Where you make a selection from one combo box, then you choices on a second combo box are restricted based on the first combo box.


Many thanks,

Sasha

 

[dcx693]

Why don't you post your question here

 

[SASHA_D]

Yeah, I guess I could of-sorry about that.
I was going off what retailers describe as 'footfall'
3,400 posts in the excel folder, compared to 45,000 in the forms folder. I have posted question in the excel bit before and not had any replies.
Do you know of a dedicated excel forum?

 

[dcx693]

If you have Access and Excel 2002, you can use an Access form to work with your Excel data. I've never done it myself, though.

Check out the following info:
Exchanging Data between Excel and Access with AccessLinks
and
Excel 2002 Add-in: Access Links

 

[SASHA_D]

Hi there,

Thanks for the reply, this looks interesting..
However, problem I have is that I have access, however the users who will be responsible for updating & adding records do not have access. At the moment data is just entered in an Excel file and an auto filter used to search for records-this is creating problems on many fields where the same information is being entered differently-different spellings, spaces etc. I need a way of adding data validation into excel plus the ability to restrict data choices available based on other fields entered. I have done it many times on access forms, not sure how I would do it in excel or even if it's possible or if there is another soloution??

Thanks again,

Sasha