last cell as label caption
one more Q. how will i go to the last cell in column b and make that the
caption for label1?
As for your second item, this will do it...
Label1.Caption = Cells(25, "B").Value
Rick
"pswanie" wrote in message
...
i got a few labels on a userform. most of them in a frame.
1) few of them need to show data in sheet1 colum a cell 1 untill empty row
2) other just need to show sheet1 column b cell 25
|