Hi

I am trying to make a message box appear automatically based on
conditions, so basically if cell range G8 has a value in it then chec
cell J8 if J8 is blank then the message box pops up and keeps poping u
till a value is entered. But if G8 is empty then nothing happens.

Little help?

Thank

--
Vlad99
-----------------------------------------------------------------------
Vlad999's Profile: http://www.excelforum.com/member.php...fo&userid=3358
View this thread: http://www.excelforum.com/showthread.php?threadid=54977

hi,
here is code that will do that. but without a better understanding of what
you are doing, i am not sure which event would be best. here i used the sheet
change event.
you may wish to conside the before save event or the before close event and
set cancel to true . that way the user will not be able save or close the
file untill your criteria is met.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Range("G8").Value = "" Then
Exit Sub
Else
If Range("G8").Value < "" And _
Range("J8").Value = "" Then
MsgBox ("this is a message")
End If
End If
End Sub

regards
FSt1
"Vlad999" wrote:


Hi

I am trying to make a message box appear automatically based on 2
conditions, so basically if cell range G8 has a value in it then check
cell J8 if J8 is blank then the message box pops up and keeps poping up
till a value is entered. But if G8 is empty then nothing happens.

Little help?

Thanks


--
Vlad999
------------------------------------------------------------------------
Vlad999's Profile: http://www.excelforum.com/member.php...o&userid=33586
View this thread: http://www.excelforum.com/showthread...hreadid=549771

sorry

well basically its a time sheet for employees to punch in and out wha
i want is for them they punch out at the end of the day for the macr
to check J8 to see if they have entered what they have worked o
today.

I used G8 because thats where their log out time goes what i was hopin
for was a macro that would check G8 (on exit or something) and check J
and if there was a value in G8 but not J8 then the message comes up t
remind them to enter what they did

--
Vlad99
-----------------------------------------------------------------------
Vlad999's Profile: http://www.excelforum.com/member.php...fo&userid=3358
View this thread: http://www.excelforum.com/showthread.php?threadid=54977