VBA with Font dialog without use comdlg.ocx

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with FTP commands in Win7+Excel2010 (VBA) 5
VBA color picker - copy of Font dialog combo box 27
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Copy value from changing cells without VBA 1
VBA: 2007 ==> 2010, How Badly Broken? 7
Using VBA coding to count color Occurrences 4
Problem with Dialogs(xlDialogWorkbookNew) 2
Common Dialog Box 2

Back
Top