Common format for Labels in Userform
Gents,
I have a Userform with about 160 labels. the label
captions are linked to the cells in the worksheet. the
cells have numeric values in them.
although i can get the userform to display each label
individually in number format.
I would like to know if there was a easy way to do this,
instead of writing 160 lines to show the format i want.
below is a format i have for each label
Label1.Caption = Format(Label1.Caption, "#,##0.00")
this is the common format i have for all the labels
thanks.....Edgar
|