Hall of Fame

1. Idle_Mind125,954
2. danaseaman67,647
3. CodeCruiser48,939
4. jpaulino44,672
5. emoreau37,575
6. webtubbs34,715
7. RobSamp...30,950
8. rorya23,350
9. abel23,150
10. matthews...21,648
11. Dhaest19,825
12. GrahamSkan18,750
13. chris_bot...18,300
14. EDDYKT17,428
15. angelIII16,672
16. BlueDevilF...15,500
17. TheLearn...15,300
18. kaufmed14,805
19. robberbaron14,100
20. Shift-313,900
21. LSMCons...12,700
22. egl104412,500
23. harfang10,700
24. mlmcc10,475
25. jppinto9,800

1. Idle_Mind653,434
2. danaseaman342,867
3. emoreau251,838
4. GrahamSkan239,830
5. vinnyd79208,855
6. angelIII188,555
7. Dabas173,271
8. jpaulino170,326
9. vb_elmar167,017
10. Dhaest162,192
11. EDDYKT155,431
12. shijusn152,523
13. TimCottee117,614
14. rorya114,475
15. Sethi109,849
16. edwardiii101,199
17. JR200398,026
18. bruintje97,512
19. ryancys91,743
20. Computron89,772
21. dbrckovi88,665
22. RobSamp...87,374
23. zzzzzooc83,209
24. PaulHews83,111
25. webtubbs78,265

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.6

Dynamically filling dropdown lists with VBA in MS Excel 2000

Asked by dirku in VB Controls

Tags: excel, vba

I have an Excel application containing a worksheet for each quarter of the year.
Each worksheet has an identical structure and I want to dynamically fill these worksheets
with dropdown lists. Each of theses dropdown lists shall have the same content which is
placed within a further worksheet.
The content of the dropdown lists shall be the name of members of a club.
The member data placed in the fifth worksheet are as follows (each as a separate column):

Lastname
Firstname
phone (home)
phone (work)

Is there a way to insert the dropdown lists into th eworksheets programmatically at runtime
or do I have to do this manually for each row?
The worksheets for eacht quarter of the year have as much rows as there are weekends in the
quarter. For each row there should be such a dropdown list to be able to choose a club member.
Furthermore, after selecting the member the appropriate phone number(s) should be
programmatically set in the corresponding columns in the same row. (I just want to choose
the member and the phone numbers will be set automatically.)
It would be great if the user could see sth. like this when selecting a row on the dropdown list:
<lastname>, <firstname> | phone(home) | phone(work)
but after selecting the member just <lastname>, <firstname> should be visible.

Thank you in advance.

Dirk
Berlin, Germany

View the Solution FREE for 30 Days

20091111-EE-VQP-92

Dynamically filling dropdown lists with VBA in MS Excel 2000

Asked by dirku in VB Controls

Tags: excel, vba

About this solution