Specific VB Excel Color Dialog

Question

Hello,

I've been looking for a very specific Color Dialog box in Excel the last couple hours, but all examples I've found aren't exactly the same. I'm looking for this Color Dialog box to incorporate into a form:

http://yfrog.com/29colorboxj

I'm not too familiar with Dialogs either... any advice is greatly appreciated!

Answer 1

you can use the windows common dialog (add additional controls to form....Microsoft Common Dialog. drop it onto form). These links should help you to get started.

http://www.freevbcode.com/ShowCode.asp?ID=1762

http://msdn.microsoft.com/en-us/library/ms646375%28VS.85%29.aspx

here is a very quick example:

Sub OpenForm()

Dim colorSelector As CommonDialog

Set colorSelector = New CommonDialog
    colorSelector.ShowColor 'opens the dialog as

MsgBox colorSelector.Color 'show result as long

End Sub