VBA with Font dialog without use comdlg.ocx
 

Hi,
As my Excel sheet have to distribute to users, OCX will cause me trouble of
licensing. I tried Application.Dialogs(xlDialogFont).Show but can't read the
return values. Can anybody suggest a way to do font dialog without much
problem now and future?

Best regards,
Joe.

VBA with Font dialog without use comdlg.ocx
 

You could use the API version for this but it is a bit long winded fo
fonts.

PLUS, when ever possible you should use native Excel commands.
In this case it would be


Application.Dialogs(xlDialogFontProperties).Sho

--
Ivan F Moal

-----------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195
View this thread: http://www.excelforum.com/showthread.php?threadid=32052