Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same task for Multiple fields
In a macro, I know you can DIM muiltiple fields to same format, but can you
do the same for labels, textboxes, etc., on a userform, ie Label1.Visible, Label2.Visible = TRUE? Thanks, Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same task for Multiple fields
"Dim" declares variables (as types, if they are included), but doesn't
assign "format". Some types have default values (e.g., a variable of type Long will be initialized with the value 0 and a variable of type Boolean will be initialized with the value False) Labels and Textboxes are objects. Objects have properties, such as the ..Visible property. Properties have default values as well. Unless the objects belong to a Collection that allows the assignment of properties for all elements of the collection (e.g., Cells.Font.Bold = True), which Labels do not, you need to assign property values individually. In article , WLMPilot wrote: In a macro, I know you can DIM muiltiple fields to same format, but can you do the same for labels, textboxes, etc., on a userform, ie Label1.Visible, Label2.Visible = TRUE? Thanks, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Viewer: multiple docs in Task bar (XP) | Excel Discussion (Misc queries) | |||
Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
Comparing multiple fields in an array with multiple fields in a table. | Excel Programming | |||
Multiple Task needed in Excel | Excel Discussion (Misc queries) | |||
Multiple Excel on Task bar | Excel Discussion (Misc queries) |