Dependent Drop Down Lists

[DocAElstein]

Hi
I will do the easy first part now, and when I have time, possibly tomorrow , I will do the more complicated second part*

Once again we have two parts to your requirement

Part one, is fairly simple: As before, the Lists for columns A and C need to made
We just have 2x4 = 8 list ranges to make normally. As previously we can do that manually or with coding.

---

First two list sets ( column A and C ranges ), with coding
I have done a couple of macros for you:

Sub MakeNormalDropDowns2x4()
This macro is basically the same basic idea as the macros for Drop down Lists 1 and 2 which I have already done for you.
But now instead of creating the lists over two ranges, ( previously A2:A8 and C2:C8 in Appraisals worksheet ) , we now are doing it for the following ranges in worksheet Actual Appraisal Form
Rem 2 SOCIAL COMPETENCIES
'2a) Topic SOCIAL COMPETENCIES List 1 in column A
A26:A27
'2b) Please Choose List 2 in column C
C26:C27

Rem 3 PERSONAL COMPETENCIES
'3a) Topic PERSONAL COMPETENCIES List 1 in column A
A29:A30
'3b) Please Choose List 2 in column C
C29:C30

Rem 4 METHODOLOGICAL COMPETENCIES
'4a) Topic METHODOLOGICAL COMPETENCIES List 1 in column A
A32:A33
'4b) Please Choose List 2 in column C
C32:C33

Rem 5 LEADERSHIP COMPETENCIES
'5a) Topic LEADERSHIP COMPETENCIES List 1 in column A
A35:A36
'5b) Please Choose List 2 in column C
C35:C36

_._____________________

I have done a second alternative for you. This is just to demonstrate how we can reduce some coding sometimes using a combination of looping and the Range Offset Property
Sub MakeNormalDropDowns1x4andLoop4times()

Both those macros are here:
https://excelfox.com/forum/showthrea...ll=1#post15111

Share ‘Appraisal - Drop Down 11 11.xls’ : https://app.box.com/s/wj11tpgc9fsuoekp023cd7ndkkqyvtm1

It should be noted, that in a situation like this there is little advantages of shortening the macro. It comes down to personal choice, mostly. The performance of the two macros will be about the same.
The shorter macro looks tidier, and possibly looks a bit more clever or professional, but is likely to be less easy to modify or understand at a later date. I personally would usually use the first macro. The final file might be a bit bigger for the longer macro, but with modern computers the extra space used rarely is of great significance.

---

I have not checked thoroughly to see if I made any simple mistakes. I leave that to you to test thoroughly.


In my next post I will tackle the second part of your current requirement.
I will do that for you tomorrow*, or when I have more time. ….

---

One last thing today, – this is just out of passing interests.
This is not part of your requirement, but I did it out of my own interest a few days ago.
You might be interested to take a quick look here:
https://excelfox.com/forum/showthrea...ll=1#post15092

It is possible to make the drop down lists appear when the cell is selected
I applied that to your initial requirement, just for fun…


Alan

---

Share ‘Appraisal - Drop Down 11 11 First Part.xls’ : https://app.box.com/s/wj11tpgc9fsuoekp023cd7ndkkqyvtm1