Advice on Using "xlDialogPatterns"

[Les Stout]

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

 

[Les Stout]

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

http://www.microsoft.com/communities/newsgroups/en-us/default.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

 

[Les Stout]

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

 

[Guest]

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

 

[Les Stout]

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

Best regards,

Les Stout