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