ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format Cells dialog box (https://www.excelbanter.com/excel-programming/277220-format-cells-dialog-box.html)

Ryan Poth[_2_]

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



All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com