so the way I have done this

1) download the Code39 font
2) format the cells using that font.

once you have downloaded and registered the font it should show up in the standard font list.
you can turn on the macro recorder and change a cell or two to the code39 font, then turn off the recorder and see the what the VBA Code should be...

HTH

that's pretty much it....