Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
label.refresh error
I attached a label control in a worksheet.
I change the caption of label by vba. This is my code: sub refreshLabel() With Activesheet .label1.caption= strMsg .label1.refresh end with end sub But I got run time error says that object doesn't support laebl.refresh property. So.. I tried another way. The code is: sub refreshLabel() With Activesheet .label1.caption= strMsg doevents end with end sub DoEvents not update too. Why excel behaves for above 2 cases? Thanks for the help Cheers |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
label.refresh error
Just remove that line, it is not necessary.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "beerora" wrote in message ups.com... I attached a label control in a worksheet. I change the caption of label by vba. This is my code: sub refreshLabel() With Activesheet .label1.caption= strMsg .label1.refresh end with end sub But I got run time error says that object doesn't support laebl.refresh property. So.. I tried another way. The code is: sub refreshLabel() With Activesheet .label1.caption= strMsg doevents end with end sub DoEvents not update too. Why excel behaves for above 2 cases? Thanks for the help Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel trendline label error | Excel Discussion (Misc queries) | |||
Refresh produces #N/A error | Links and Linking in Excel | |||
On Error GoTo Label in a loop only working once. | Charts and Charting in Excel | |||
Type Mismatch Error Populating Label | Excel Programming | |||
Refresh label on user form with RefEdit | Excel Programming |