VB Help: Pop up window alert in excel when a certain date gets reached

[kanic222]

Hello,

I have worked with excel a long time but I have no coding ability to utilize VBA. I have an excel document that is updated daily and are need of alerts (is possible) that would help us stay on top of certain data. We enter data across the rows for every item entry we process. In column G we have a value that gets entered lets say its "REG" for every REG item row there are 2 alerts that need to be given. when column B equals 10 we have to have an alert to " give credit" and on column AD we sometimes put a date on if we have to take away a credit (sometimes the field is left blank). Is there a way this could be coded in VBA? Any reference materials I can look at? Any help is very much appreciated

 

[silentwolf]

Hi Kanic222
take a look at the www.wiseowl.co.uk there are many tutorials which will get you started on vba..
As with everything you can do things in many different ways.. so take a look at the tutorials and getting familiar with vba and then when you know exactly what you like to do you can post a concrete question about it and I am sure with many on here they will be able to help.

Hth
Albert

 

[My Aswer Is This]

So any time REG is entered into column G and Column B same row equals 10
You want a Message Box to popup saying "Give Credit"
Is that what you want?

And I did not understand when second alert should popup.
You said:

and on column AD we sometimes put a date on if we have to take

So are you saying if any value is entered in Column AD a message should popup saying what?​

 

[kanic222]

Yes

and second part is

For any time REG is entered into column G and Column AD's Date, same row equals today. id want a message to "take credit"

I wasnt sure if mentioning that column AD doesnt always have a date in it mattered or not. but when it does we would need an alert as the action is required on the date in the cell for that REG row

So any time REG is entered into column G and Column B same row equals 10
You want a Message Box to popup saying "Give Credit"
Is that what you want?

And I did not understand when second alert should popup.
You said:

and on column AD we sometimes put a date on if we have to take

So are you saying if any value is entered in Column AD a message should popup saying what?​

 

[kanic222]

Hi Silentwolf,

Thank you for the reference site.

Hi Kanic222
take a look at the www.wiseowl.co.uk there are many tutorials which will get you started on vba..
As with everything you can do things in many different ways.. so take a look at the tutorials and getting familiar with vba and then when you know exactly what you like to do you can post a concrete question about it and I am sure with many on here they will be able to help.

Hth
Albert

 

[My Aswer Is This]

See if this does what you want for the first part of your needs
This script runs when you enter REG in column G

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  8/30/2018  6:32:52 PM  EDT
If Not Intersect(Target, Range("G:G")) Is Nothing Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
If Target.Value = "REG" And Target.Offset(, -5).Value = "10" Then MsgBox "Give Credit"
End If
End Sub