Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
thanx rick...
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
force numbers as text as seen on screen | Excel Discussion (Misc queries) | |||
force Excel to treat numbers as text | New Users to Excel | |||
force evaluation of text | Excel Discussion (Misc queries) |