Populate Validation List and do loop until cell value is meet

Hi Experts,

Currently, I have a code to create a validation list that ignore empty cell from Column(B) of Worksheet(Data) at cell "L5" and has a formula at "M5" to lookup left value of "L5".

This is what I want to achieve:
Step 1. Create a validation list at "L5" and return lookup value at "M5"
Step 2. repeat step 1 until the value at cell "A1"

I am not good at this. I appreciate and help that improve this code.

See attached sample excel file.

can you clarify this?

Step 2. repeat step 1 until the value at cell "A1"

and by this.....

Step 1. Create a validation list at "L5" and return lookup value at "M5"

....you mean that you want the value chosen in the dropdown from ''L5'' to appear in the cell ''M5''?

don't worry, the people around here are very nice. we'll help. you don't have to be good. as long as you're willing to learn. you can learn for a lifetime with stuff!

Hi vba_php,

Sorry for the confusing explanation. I try again I hope it will be clear this time.

step1 : I have a selection change event of worksheet to create validation list in cell "L5", the value selected will appear in cell "L5". I also have a lookup formula on "M5", if it is possible to replace the formula as part of the vba code.
step2 : create the same validation list in cell "L6" up to "Lx", where x is the value in Worksheets("Main").cells("A1")

Selection Change event code:

Please Login or Register  to view this content.

you said: I also have a lookup formula on "M5", if it is possible to replace the formula as part of the vba code.

almost anything you can do through the interface, you can also do with code. the reason for this is simple. Excel was written with code.

you also said: create the same validation list in cell "L6" up to "Lx", where x is the value in Worksheets("Main").cells("A1")

so, if you want to create the EXACT same dropdown menu that is in cell ''L5'' for every cell beneath it, for a cell count listed in ''A1'' on the main tab, then more than likely all you have to do is tell Excel to teach you. see what I did here:

https://drive.google.com/file/d/1KGl...ew?usp=sharing

and the code that Excel wrote for me, after I modified was this:

Please Login or Register  to view this content.