I am having trouble with my Macro:
Sub AlertUser(Value As Long)
For Each c In Worksheets("ExpenseForm").Range("C20:J20")
If c.Value > 0 Then
c("A30").AddComment ("Must Fill out Description Meals Section!")
End Sub
I would like to have a macro that remains in the worksheet ("Expense Form") and will alert the user when a value is entered into Cell C20:J20 by either a comment or msgbox alert! I have tried running my attempt above, but nothing happens when I enter a value in C20?
Perhaps someone could point me in the right direction?
Thanks
Sub AlertUser(Value As Long)
For Each c In Worksheets("ExpenseForm").Range("C20:J20")
If c.Value > 0 Then
c("A30").AddComment ("Must Fill out Description Meals Section!")
End Sub
I would like to have a macro that remains in the worksheet ("Expense Form") and will alert the user when a value is entered into Cell C20:J20 by either a comment or msgbox alert! I have tried running my attempt above, but nothing happens when I enter a value in C20?
Perhaps someone could point me in the right direction?
Thanks