Your question is about a whole programming topic.

To begin, you may go to Visual Basic Editor, call the Help, and type "IF
statement" in the search box. Then choose "Using If...Then...Else Statements".

The on-line help is a very useful source of technical information.

Regards,
Edwin Tam

http://www.vonixx.com



"hccatmo" wrote:

I'd like to writer a macro to execute certain activities dependent on the
value of a cell.
Thx.
cg