B
beerora
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
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