View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default shape object on a userform?

Hi,

As the other guys have said it's not straightforward.
But you may find you can make use of the techniques I use in my example.
http://www.andypope.info/vba/userformdraw.htm

Cheers
Andy

Alan Ibbotson wrote:
I want to create a UserForm1. On the UserFrom I want to create a Trapazoid
shape object and three text boxes. The text boxes would define the trapazoid
height and both lengths. When the user inputs a new number in the text box
the trapazoid shape would change size.

Is this possible?

If I could get the shape drawn on the UserForm I believe I could code the
rest. TIA.

Alan



--

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