View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default shape object on a userform?

That's awesome stuff, Andy!

Regards,

Vasant

"Andy Pope" wrote in message
...
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