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.

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


"Zone" wrote in message
oups.com...
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.

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 wrote:
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.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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!

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



"Zone" wrote in message
oups.com...
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!