Hi everyone. Somehow I think I should know this but the answer is
just not stepping up.

In Excel for example I know to use this formula for finding out if a
cell has data in it. =IF(F18<"","Yes","No")

What is the syntax for doing this VBA?

if cboDepartment (HAS a value) then do this, otherwise do this.

Thanks in advance!

-LT