Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using excel 2003. How would I programmatically create a label in
a worksheet. The following doesn't work: Dim mylabel As Label mylabel.Visible = True mylabel.Caption = "my caption" Is there a way to programmatically create an array of labels by doing Dim mylabels(5) as label? Then could I create/delete the label as needed by using mylabel.create (or whatever the appropriate method is) and mylabel.delete? if I want a new function that performs an action on several different labels can I give it a label/array of labels as a parameter by declaring the function with something like: Function my_label_function(changelabel as label) as integer Thanks, David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Programmatically create button on Excel worksheet (vb.net) | Excel Programming | |||
How do I use a worksheet label to create a formula in Excel 2007? | Excel Discussion (Misc queries) | |||
How do I use a worksheet label to create a formula in Excel 2007? | Excel Discussion (Misc queries) | |||
label x-axis values programmatically | Charts and Charting in Excel | |||
Create UserForm programmatically | Excel Programming |