Hi All,

I have a label which will display the status message.A macro will
assign the message to be displayed in the Label. After assigning
message the macro calls another method which copies the data to the
excel. This will excute for few minutes.

Here, am first assigning the message for the Label. But the assigned
caption is visible only after coping the data to excel.

I want to display the message in the label before starting to copy the
data.

Am not using any *ScreenUpdating *methods.

Please help me out how to accomplisth this..

Thanks & regards,
Abhi Ram Bysani.


--
abiram01
------------------------------------------------------------------------
abiram01's Profile: http://www.excelforum.com/member.php...o&userid=33347
View this thread: http://www.excelforum.com/showthread...hreadid=555950