Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display color (or Format Cells) dialog in a macro?
If I use the following in a macro, how can I get the selected color after the
user clicks the OK button? Is there another way to display a color selection dialog? Or, better yet, how can I display the 'Format Cells' dialog in a macro? Dim bResult As Boolean bResult = Application.Dialogs(xlDialogColorPalette).Show |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display color (or Format Cells) dialog in a macro?
The selected cell will be formatted when the user makes a selection from the
dialog. So you can read the color from the cell. Or, better yet, how can I display the 'Format Cells' dialog in a macro? application.CommandBars("Format").Controls(C&ells. ..").Execute -- Regards, Tom Ogilvy "Mick" wrote in message ... If I use the following in a macro, how can I get the selected color after the user clicks the OK button? Is there another way to display a color selection dialog? Or, better yet, how can I display the 'Format Cells' dialog in a macro? Dim bResult As Boolean bResult = Application.Dialogs(xlDialogColorPalette).Show |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No Format Cells dialog box | Excel Discussion (Misc queries) | |||
Format Cells Dialog Box | Excel Discussion (Misc queries) | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Format Cells dialog box | Excel Programming |