| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
| How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
| Changed default font, previous font still shows when editing | Excel Discussion (Misc queries) | |||
| Changed default font, previous font still shows when editing | Excel Discussion (Misc queries) | |||
| control of dialog macro dialog box. on open | Excel Programming | |||
Linear Mode
