Event handler...

[bahllr]

I am looking for some code that will populate a number of items when a certain cell is selected in excel. I know how to set up all the code for populating cells based on the initial selection (drop down box with 3 choices).....I just don't know how to have the code operate automatically when the a choice is selected from the drop down box (cell b1).

Any ideas would be much appreciated!

 

[Colin Legg]

Hi,

You'll want the worksheet's change event handler for this.

If you right click on the worksheet's tab and choose View Code, the VBE will open with the worksheet's class module active. You can then paste in this code as a starting template:

Private Sub Worksheet_Change(ByVal Target As Range)
 
     'check that B1 is the cell that was changed
     If Not Intersect(Target.Cells(1), Range("B1")) Is Nothing Then
     
          'your code in here
        
          
     End If
     
End Sub

Hope that helps...

 

[bahllr]

Thanks, Colin_L. That was just what I needed!