Well, if anyone is interested here's my file: It's the button lable
search for all employees by city,title,service,and salary that I a
having problems with....thanks again for everyone's help

--
scape
-----------------------------------------------------------------------
scapen's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26789

try this

If QualifiedEmployees = 0 Then AverageSalary = 0
else averagesalary= whateveryouwant - you need to define this
If QualifiedEmployees = 0 then
MsgBox "There are no employees who meet all of the criteria. _
Please rerun the macro."
Else
MsgBox "Macros are made more powerful by adding _
VBA statements."
End If
end su

--
duan
-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=26789