-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Activate macro when data is entered into a cell
- Thread starter RogerC
- Start date
Yes, this is possible.
Say you want to run your macro if data is entered into range A1:D10
Right click the worksheet tab and click View Code. This will open the code module of that worksheet. Use code like this:-
<pre>
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("A1:D10")) Is Nothing Then YourMacroName
End Sub
</pre>
The worksheet change event is one of Excel VBA's built in events. You can write code like that above to repond to user actions.
Say you want to run your macro if data is entered into range A1:D10
Right click the worksheet tab and click View Code. This will open the code module of that worksheet. Use code like this:-
<pre>
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("A1:D10")) Is Nothing Then YourMacroName
End Sub
</pre>
The worksheet change event is one of Excel VBA's built in events. You can write code like that above to repond to user actions.
Upvote
0
Dan- thanks so much for your help. I tried using your code... substituting my data range and the name of my macro for YourMacroName, of course. When I enter data into my range I get a 'Compile Error - Ambiguous Name Detected: Worksheet_Change'. Can you tell me what to look for now? BTW, I'm using one other WorkSheet_Change Private Sub in the same worksheet and it works fine. Thanks!
Upvote
0
Similar threads
- Question
