Drop Down boxes
Hi guys,
I am a Access programmer who needs to add a few drop down boxes in a excel worksheet with a second worksheet as my data source but i am finding it alot different then Access combo boxes and table lookups. I have the data validation part down for the first drop down box but I want to populate the second drop down box depending on what was selected fromt the first drop down box. Can you please explain and show me an example of how this can be done? Any help would be greatly appreciated. -- Thanks in advance, Matt (access 2000) |
Drop Down boxes
Matt,
Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html -- HTH RP (remove nothere from the email address if mailing direct) "MaBell" wrote in message ... Hi guys, I am a Access programmer who needs to add a few drop down boxes in a excel worksheet with a second worksheet as my data source but i am finding it alot different then Access combo boxes and table lookups. I have the data validation part down for the first drop down box but I want to populate the second drop down box depending on what was selected fromt the first drop down box. Can you please explain and show me an example of how this can be done? Any help would be greatly appreciated. -- Thanks in advance, Matt (access 2000) |
All times are GMT +1. The time now is 01:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com