Niek,

Wouldn't a worksheet_change event involve less overhead?

--
Don Guillett
SalesAid Software

"Niek Otten" wrote in message
...
Look he

http://xldynamic.com/source/xld.QDEDownload.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sue Miller" <Sue wrote in message
...
|I want to be able to enter, for example, "030107" and have the cell
formatted
| so I get 03/01/07.