New to VBA

[otuatail]

Hi I have used VBA and visual basic before

I want a macro that changes the value of a cell when another cell is updated.

I.E. Cell C2 = (A2 + B2)

If the value in cell C2 is greater than 10 Then text in Cell D2 could say Over limit.

I have this code in a module

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$2" Then
If (C2.Value > 10) Then
D2.Value = "Over limit"
Else
D2.Value = "Okay"
End If
End If
End Sub

Am I on the right track here.

[davesexcel]

Check out Worksheet_Calculate instead

[otuatail]

Ok I have googled that and found nothing. I have changed the code to

Private Sub Worksheet_Calculate(ByVal Target As Range)
If Target.Address = "$C$2" Then
If (C2.Value > 10) Then
D2.Value = "Over limit"
Else
D2.Value = "Okay"
End If
End If
End Sub


But don't I need to link the function to cell C2?

I am new to this.

[davesexcel]

Please Login or Register  to view this content.

[otuatail]

Well I have put that code into the module1 and nothing is happening. Do I need a trigger event of some kind. The code is not running.

I can put a button on the sheet and run code that way

[davesexcel]

It goes in the worksheet module, right click the sheet tab and select view code.

[otuatail]

Ok Thanks. That works now. I did have a button on the form but when I moved it from the module to the worksheet it didn't.

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )