HighAndWilder
Well-known Member
- Joined
- Nov 4, 2006
- Messages
- 606
- Office Version
- 365
- Platform
- Windows
Hi
I'd like to load Excel BuiltIn Dialog Boxes by using the following line of code or similar and where the strDialogBox variable contains the
name of the Dialog Box to load.
strDialogBox="xlDialogFontProperties"
Application.Dialogs(strDialogBox).Show
How would I do this?
I'd like to open the Format Cells Dialog Box but I'm not sure which one it is. I'd like to be able to select a certain Tab on the Dialog Box, e.g. Fill or Font.
Any ideas anybody?
Thanks
I'd like to load Excel BuiltIn Dialog Boxes by using the following line of code or similar and where the strDialogBox variable contains the
name of the Dialog Box to load.
strDialogBox="xlDialogFontProperties"
Application.Dialogs(strDialogBox).Show
How would I do this?
I'd like to open the Format Cells Dialog Box but I'm not sure which one it is. I'd like to be able to select a certain Tab on the Dialog Box, e.g. Fill or Font.
Any ideas anybody?
Thanks