MsgBox Alert

[Ike Hunter]

Hello All,

I'm looking for vba for the following situation.

On tab labeled "Orders"
Sheet4 (Orders)

Event trigger = When data is entered into the first empty cell(s) of Column F

Then check to see if the following three conditions are true

1st - Column C - a cell has the phrase 2) Replacement Only
2nd - Column B - same row, cell has a date that is... older than today
3rd - Column F - same row, has a cell that is... blank

When all three conditions are met then a Message box: A Replacement Only Order Did Not Ship

It would be cool if the message box could report how many instances occurred. If not, it wouldn't be necessary for multiple Mesg box pop ups for each instance. (Just one alert)


Thank you in advance.

 

[MikeDBMan]

I hope someone answers this because I have always had a bit of difficulty capturing where the cursor was BEFORE the function Worksheet_SelectionChange is called. I usually capture the data into public variables but it has its issues and is hard to work with sometimes.