View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan Poth[_2_] Ryan Poth[_2_] is offline
external usenet poster
 
Posts: 18
Default Format Cells dialog box

I cannot recall if I've posted this question to this board
before, but if I did, I don't think I got an answer.

I'm trying to access the "Format Cells" built-in dialog
box, which appears to be a combination of several (6)
individual dialog boxes: Number, Alignment, Font, Border,
Patterns, Protection. I can access each of these
individually as follows:

Application.Dialogs(xlDialogFormatNumber).Show
Application.Dialogs(xlDialogAlignment).Show
Application.Dialogs(xlDialogFontProperties).Show or
Application.Dialogs(xlDialogActiveCellFont).Show
Application.Dialogs(xlDialogBorder).Show
Application.Dialogs(xlDialogPatterns).Show
Application.Dialogs(xlDialogCellProtection).Show

However, I would like to access them as one, like they
appear when you choose Format Cells. Does anybody have any
insight into this?

Thanks in advance,
Ryan