Drawing Object in a Userform
 

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.

Drawing Object in a Userform
 

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.

Drawing Object in a Userform
 

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

Drawing Object in a Userform
 

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!

Drawing Object in a Userform
 

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!