ExcelBanter - Value From xlDialog

Quoting from Tom Ogilvy:
"The dialog is the same as selecting this from the menu - it performs a
specific action which is to color the cells that are selected. It isn't a
general purpose dialog that you can use as a color picker. So the answer is
no as far as any builtin in capability you can employ to do this."

However, If you color the selection, you can get that information from the
selection...
'/=======================================/
Sub test()
MsgBox "Background color: " & Selection.Interior.ColorIndex
MsgBox "Font color: " & Selection.Font.ColorIndex
End Sub
'/=======================================/

HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.

"Brad" wrote:

Thanks for taking the time to read my question.

How do I get the value of the selected option when I use this?

- - - - - - - -
Application.Dialogs(xlDialogPatterns).Show
- - - - - - - -

Say I choose red, what it that value?

Thanks,

Brad