View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
beerora beerora is offline
external usenet poster
 
Posts: 1
Default 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