Thank you but I understand how to format a cell as a zip code but the problem
is when I do that my code doesn't work any more. What am i missing in my
code or in the formatting of the textbox (tbZipCode) that won't allow it to
return the values when the cell is formated as a Zip Code.

"AndrewArmstrong" wrote:

You can use the Format Cells - Number - Special - Zip Code format