| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Forms in excel 2007 | Excel Programming | |||
| Help with programming Excel User Forms | Excel Programming | |||
| User Forms - getting them to talk to Excel | Excel Programming | |||
| User Forms and Excel Functions | Excel Programming | |||
| User forms in Excel | Excel Programming | |||
![Rick Rothstein \(MVP - VB\)[_1973_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
