Run Macro after Data Validation

[pagrender]

Hello all,

I don't know if this is possible, but I thought I'd ask anyway.

I have data validation in cell B9 of the "Chart" tab. When the user makes a selection from the drop-down menu, is it possible to have Excel automatically run the "CreateChart" macro?

Thanks!

 

[Tom Urtis]

The theoretical answer is Yes, this is possible, using the info you posted, for the "Chart" worksheet where the data validation in cell B9 is, right click on that sheet tab, left click on View Code, and paste this into the large white pane that is the worksheet module. Press Alt+Q to return to the worksheet.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$B$9" Then Exit Sub
If IsEmpty(Target) Then Exit Sub
Run "CreateChart"
End Sub

The success of the result will depend on the CreateChart macro, but the above steps would be the general approach.

 

[Smitty]

You can use a change event:

<font face=Calibri><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Change(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range)<br>    <SPAN style="color:#00007F">If</SPAN> Target.Address = "$B$9" <SPAN style="color:#00007F">Then</SPAN> Applcation.Run "CreateChart"<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

 

[pagrender]

This worked. Thank you so much for your help.