Hi all, i am sure this is simple for the guru's out there.. How does
one, after making a color selection on the dialog get the value to use
as a variable ?

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

I have found the answer on another site at the following address, thank
you...

http://www.microsoft.com/communities...ult.aspx?query
=xldialogpatterns&dg=microsoft.public.excel.programming&cat=en_US_3a793e
1f-4961-419d-9ec7-899d6e6086cd&lang=en&cr=US&pt=&catlist=&dglist=&ptlist
=&exp=&sloc=en-us

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Sorry, just a further question to this.
Does the dialog box only color the active cell or can it be forced to
color another cell ???

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Just as I stated in the link you cited, it is like doing it from the menu -
so only the selection at the time you make the selection.

You might want to look at John Walkenbach's site. He has done all the hard
work of putting together a color picker on a userform:

http://www.j-walk.com/ss/excel/tips/tip49.htm

--
Regards,
Tom Ogilvy


"Les Stout" wrote:

> Sorry, just a further question to this.
> Does the dialog box only color the active cell or can it be forced to
> color another cell ???
>
> Best regards,
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***
>

Thank you so much Tom, that is exactly what i was looking for...

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***