Thread: Autoshapes on Excel user forms
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1973_] Rick Rothstein \(MVP - VB\)[_1973_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote