Autoshapes on Excel user forms

[buattis]

Hi everyone,

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

Regards
Stefano

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Norman Jones]

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

 

[Rick Rothstein \(MVP - VB\)]

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