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

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