Autoshapes on Excel user forms
 

Hi everyone,

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

Regards
Stefano

Autoshapes on Excel user forms
 

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

Autoshapes on Excel user forms
 

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

Autoshapes on Excel user forms
 

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