Drop Down List in Shape

Hi Group,

i am an absolute beginner in Shape creation - so I would be glad in for any
help:

I want to create a Shape, that has a drop down list (user can select from
pre defined values) and according to the value
I would also like to change the (back)color of the shape.

Any Ideas or Hints ????


Thanks

Jerry

Hi Jerry

I have some tips for you:

You have to create a shape first. Then open the ShapeSheet. Insert section
CustomProperties. Add 2 rows to it:
first row: Color, Type=4, Format="black;white;red;green;blue;yellow"
second row: ColorIndex, Value=LOOKUP(Prop.Color,Prop.Color.Format)

Next go to section Fill Format and change cell Fill Foregnd to
=Prop.ColorIndex

When you select the shape and display the CustomProperties window you can
select the color.
Thats all


"JerryP" <jerryp_vienna.TakeThisOut@hotmail.com> wrote in message
news:Oepalq17DHA.1816@TK2MSFTNGP12.phx.gbl...
 > Hi Group,
 >
 > i am an absolute beginner in Shape creation - so I would be glad in for
any
 > help:
 >
 > I want to create a Shape, that has a drop down list (user can select from
 > pre defined values) and according to the value
 > I would also like to change the (back)color of the shape.
 >
 > Any Ideas or Hints ????
 >
 >
 > Thanks
 >
 > Jerry
 >
 ><!-- ~MESSAGE_AFTER~ -->