Hi everyone,

Is it possible to draw autoshapes on excel user forms with code on
form load?

Regards
Stefano

Is it possible to draw autoshapes on excel user forms with
code on form load?

Yes, look up the AddShape method of the Shapes Collection. Here is an
example...

Worksheets("Sheet1").Shapes.AddShape msoShapeCloudCallout, 20, 40, 50, 60

Rick

Hi Stefano,

=============
Is it possible to draw autoshapes on excel user forms with code on
form load?
=============

There is no in-built way to add a shape to a
Userform

You could, however use a label or an image
control to display a picture of the shape.

See, for example, Andy Pope at:

Drawing on userform
http://www.andypope.info/vba/userformdraw.htm



---
Regards.
Norman

Hmm! You said "user forms" (two words) and I thought you meant a worksheet
"form"... Norman read that you meant UserForm (one word)... I'm guessing
Norman is probably right.

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Is it possible to draw autoshapes on excel user forms with
code on form load?

Yes, look up the AddShape method of the Shapes Collection. Here is an
example...

Worksheets("Sheet1").Shapes.AddShape msoShapeCloudCallout, 20, 40, 50, 60

Rick