MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Krijg Tieten on September 21, 2001 5:47 AM

Does anybody knows how to let a messagebox appear when cell D11 is a value and cell G11 is empty? I've got a code but it doesn't work! Anybody who knows what's wrong with it?

The code I have:

Sub Change()
If Not Worksheets("Sh1").Range("D11") Is Nothing And Worksheets("Sh1").Range("G11") Is Nothing Then
Display = MsgBox("Put something in G11", 48, "ERROR")
Exit Sub
End If

I hope someone can help me out?

Posted by Barrie Davidson on September 21, 2001 6:04 AM

Krijg, try putting this code in your worksheet's code (access this by right clicking on the worksheet tab and selecting "view code").

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Range("D11") <> "" And Range("G11") = "" Then
MsgBox prompt:="Put something in G11", Buttons:=vbExclamation, Title:="Error"
End If
End Sub

BarrieBarrie Davidson