PDA

View Full Version : Problem with font



kirkmc
07-07-2009, 06:35 PM
Hi,
After a Windows re-install one of my Excel files doesn't work as before.
I've figured out the problem - or solution - is in Excel, not Windows
but can't find the cause.

A UserForm gets its information from a Worksheet. One of the characters in the worksheet is chrW(9660). This character shows on the worksheet
OK but no longer on the Form, where it's changed to a small box shape.
I don't think it's a missing font issue though, rather I'm guessing this 9660 char (Unicode?)is disabled or not present in the current enviroment.

I have an xls file with an example of the issue at
http://kirk.orconhosting.net.nz/testchrw.xls
(Please be aware this has a macro the runs the Form in the Workbook Open event.)

Any help or solution with this would be most appreciated.
Thanks - Kirk

Slim
07-07-2009, 09:55 PM
Have you tried in EXCEL / Help/ Detect and Repair/

kirkmc
08-07-2009, 12:58 AM
Thanks for the suggestion. Just did that and it completed
successfully but the problem remains

DUNK
08-07-2009, 01:43 AM
If it actually is a font problem.
Try going :- "Start" >"Run" > Fontreg. :2cents: