View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default Colors programatically


Very nice. Thank you.

"Dave Peterson" wrote:

For the font color:
Application.Dialogs(xlDialogFormatFont).Show
or
Application.Dialogs(xlDialogFontProperties).Show


For the pattern/fill:
Application.Dialogs(xlDialogPatterns).Show



Steven wrote:

What code do I use on a command button that will let the user choose a color
for interior and font.

Thanks you,

Steven


--

Dave Peterson