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:
If Not Worksheets("Sh1").Range("D11") Is Nothing And Worksheets("Sh1").Range("G11") Is Nothing Then
Display = MsgBox("Put something in G11", 48, "ERROR")
I hope someone can help me out?