I am looking at doing a simple application that allows the user to do
some simple floorplanning of some rectangles. I developed an addin that
provides an initial estimate of the size of the rectangles. Some
rectangles are fixed size and some can vary in x/y dimension but must be
fixed area. I would like to use TextBox shapes but they do not accept
events for the dynamic resizing. I looked at using text box controls
but they cannot be resized by dragging the corners at runtime. Does
anyone know of a control that can be dynamically resized at runtime and
produces events to control the resizing. I would like the user to drag
the sides of the control to size it. I will need to dynamically create
100's of rectangles so it must work with Class modules (WithEvents).

There are other products that can do this but it would very easy for the
user to do this in excel rather than switch to another application.

Regards Bill Bell