Dropdown and changes

[eyemgod]

I have a drop down in a cell with 2 values. "AA", "BB" (This is located on Cell B1

When you select the Value "AA" I want the title of my list to be something in particular.

the List start on row 3
Example: Colum 1 (AA1), Column 2 (AA2)

If you change the value in B1 to "BB" then the title would change
Column 1 (BB1), Column 2 (BB2)

Hope this is understandable.

I try with Private Sub Worksheet_Change(ByVal Target As Range).
but everytime it changes the first value of the list, the function start over since is another change.
Can I stop it somehow to start over or is there a different way I could do that.

Thanks in advance

Andre

 

[Von Pookie]

Use Application.EnableEvents=False and Application.EnableEvents=True at the beginning and end of your code.

It will stop the change from triggering the macro again.