How can VB present a dialog for a user to select a color value

[gpsmith]

Is there a way to programmatically present to the user a dialog so theny can select a color value that the code can then subsequently use to color a range of cells?

e.g. I would like to present to the user a dialog similar (the same would be better) to what happens if you choose Format->Cells->Patterns which results in a color dialog being presented to you so you can choose a color value.

Thanks,
George

[Charles]

Hi,

See if this helps.

http://spreadsheetpage.com/index.php...er_dialog_box/

[Andy Pope]

You can use the built in dialog

Please Login or Register  to view this content.

it will alter the activecell