in the simplest form
if selection.value=range("a1") then msgbox "Hi"

--
Don Guillett
SalesAid Software

"Donna S" <Donna wrote in message
...
I'm trying to write a simple if statement that looks at an active cell and
compares is to the data in another cell. So far I have:

If Selection.Value = ??????? Then

Please help me fill in the ???????. This is probably very simple but I'm
just learning.

Thanks,