Format Cells dialog box

R

Ryan Poth

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
 

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

Show Format Cells Dialog Box? 0
Opening Built-In Custom AutoFilter Dialog Box Programmatically 2
[Excel 2007] Maybe a bug with Dialogs(xlDialogSaveAs) 2
Show "Go To Special" Dialog Box 2
Display color (or Format Cells) dialog in a macro? 1
Another Question about Save As Dialog box 3
The Dialogs collection 2
VBA color picker - copy of Font dialog combo box 27

Top