Trying to create a macro using IsEmpty function in vba.
Once a particular field is not empty then it will return a message stating "cell e30, e31, e36 and e38 etc requires user input". That part was easy but I am having trouble figuring out how to get the message to go away after the required fields are filled. This seems simple but I am a novice at excel and need a little help.
Function used to get msgbox
If IsEmpty(Range("E29")) = False Then
MsgBox "Cell E30 requires user input"
End If
Bookmarks