Drawing Object in a Userform

[Zone]

Is there anyway to insert a drawing object in a userform? I would like
to have a rectangle in there so the user can use spinner controls to
try out changes to RGB colors. Alternatively, is there a way to get
this info from the standard Excel userform? Excel2002.

 

[Chip Pearson]

Excel user forms don't support shapes. For a rectangle, use the
Frame control and set the caption to an empty string.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Andy Pope]

Hi,

Can you not use a Label control?
You can adjust the backcolor using the RGB() function, picking up the
Red, Green and Blue values from the spinner controls.

Cheers
Andy

 

[Zone]

Thank you, Chip and Andy. This is a great help. Chip's frame works
well for the fore and back colors. To complicate matters, I want to be
able to select a pattern to mix the fore and back colors. Don't see
any access to that in the properties. I thinking of just opening
another spreadsheet with a drawing object on it and using spinners on a
userform to set fore RGB, pattern and back RGB unless you have better
idea. At any rate, thanks again!

 

[Peter T]

One cluncky way might be to adapt Stephen Bullen's PastePicture.xls (.zip)
www.oaltd.co.uk

hide your chartobject somewhere, format the chartarea with no series data /
plot.

Why not let user apply pattern formats directly to selection and see changes
in real time, that's what I do (and a lot else!).

Regards,
Peter T