View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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.