Populate Fields with Data (Pivot Tables?)

[excelinear]

Hello,

I would like to have two drop down lists and a scrolling list that can be used to populate several fields. The first drop down list will allow the user to select a country, the second drop down list will allow the user to select a state, and a scrolling list will allow the user to select the county. The scrolling list will display 10 counties at a time and the user can scroll to their desired county. The user will select a county by clicking on it and several text boxes will be populated with data for that county. All of this data is located on another sheet within the same workbook.

What is the best way of doing this? Can I use a Pivot Table to make the selections and populate separate text boxes?

Thanks!