Showing the "Fill Colors" Office dialog box programmatically

[Marty Lee]

Howdy All,

I accidently posted this message to the Using Drawing
And Graphics group a few minutes ago. My apologies to
those reading this twice.

Is it possible to present the "Fill Colors" dialog box
and retrieve the user's selection in VBA? [The "Fill
Colors" dialog is represented by the "pouring paintbucket"
icon in the drawing toolbar].

If it is possible, can I show those options in a
standard Office 2000 user form? I. E. how do I get an
empty label or a rectangle in the form to format with one
of the textures found in the Fill Colors dialog?

Thank you!
Marty
(sorry about the slight corruption of the return email
address, which is properly ".msn" not ".nsm" I'm trying to
avoid spammers).

 

[Marty Lee]

Howdy Again,

I think that I have a solution to this cartalk
puzzler. It turns out that there is a built in dialog
box, wdDialogFormatDrawingObject, that has a page for
Color. If you specify color on this page then you get the
sub-form that permits you to specify textures, patterns,
etc. It is still not clear if these qualities can be
shown on a form, but it may prove a route to capturing the
request.

Marty

 

[Word Heretic]

G'day "Marty Lee" <[email protected]>,

what about creating a temp dummy object to be the target of the dialog
so you can just read its value before killing it?

Howdy All,

I accidently posted this message to the Using Drawing
And Graphics group a few minutes ago. My apologies to
those reading this twice.

Is it possible to present the "Fill Colors" dialog box
and retrieve the user's selection in VBA? [The "Fill
Colors" dialog is represented by the "pouring paintbucket"
icon in the drawing toolbar].

If it is possible, can I show those options in a
standard Office 2000 user form? I. E. how do I get an
empty label or a rectangle in the form to format with one
of the textures found in the Fill Colors dialog?

Thank you!
Marty
(sorry about the slight corruption of the return email
address, which is properly ".msn" not ".nsm" I'm trying to
avoid spammers).

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email: (e-mail address removed)
Products: http://www.geocities.com/word_heretic/products.html
Spellbooks: 728 pages of dump left and dropping...

The VBA Beginner's Spellbook: For all VBA users.

 

[Marty Lee]

Thanks, Again, Heretic

Your's is a much more workable suggestion. My approach
proved to be problematic - I found it very difficult to
determine which combination of dialog boxes and parameters
would give me access to the properties that were needed.

Marty

-----Original Message-----
G'day "Marty Lee" <[email protected]>,

what about creating a temp dummy object to be the target of the dialog
so you can just read its value before killing it?

Howdy All,

I accidently posted this message to the Using Drawing
And Graphics group a few minutes ago. My apologies to
those reading this twice.

Is it possible to present the "Fill Colors" dialog box
and retrieve the user's selection in VBA? [The "Fill
Colors" dialog is represented by the "pouring paintbucket"
icon in the drawing toolbar].

If it is possible, can I show those options in a
standard Office 2000 user form? I. E. how do I get an
empty label or a rectangle in the form to format with one
of the textures found in the Fill Colors dialog?

Thank you!
Marty
(sorry about the slight corruption of the return email
address, which is properly ".msn" not ".nsm" I'm trying to
avoid spammers).

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email: (e-mail address removed)
Products: http://www.geocities.com/word_heretic/products.html
Spellbooks: 728 pages of dump left and dropping...

The VBA Beginner's Spellbook: For all VBA users.
.