Thread: If cell empty dont run macro
View Single Post
  #2  
Old 06-18-2009, 05:22 PM
JBeaucaire's Avatar
JBeaucaire JBeaucaire is offline
Forum Guru
  
Join Date: 21 Mar 2008
Location: Bakersfield, CA
MS Office Version:2003 (can read 2007 files)
Posts: 9,517
JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay
Send a message via Skype™ to JBeaucaire
Re: If cell empty dont run macro
Start of like this...
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Range("B5")) Then
    MsgBox "Cell B5 is not supposed to be empty..."
    Exit Sub
End If

....continue your macro
__________________
If you've been given good help, use the icon in that post to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Reply With Quote