You can use Format Conditional Formatting without the need for code,
Select 'Not equal to' in the droplist, 0 in the box to the the right and hit
'Format' to select the border,
Regards,
"Michelle" wrote in message
...
Is there a way to write code that automatically creates a
border around a cell after text is entered into it?