Label's caption is not assinged immediatly..
 

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

Label's caption is not assinged immediatly..
 

Is this label on a userform?

Look at RePaint and maybe DoEvents.

abiram01 wrote:

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

--

Dave Peterson

Label's caption is not assinged immediatly..
 

The label is present on work sheet.

The message needs to be dispalyed is assigned but not displayed till
the task is completed.

Dave Peterson Wrote:
Is this label on a userform?

Look at RePaint and maybe DoEvents.

abiram01 wrote:

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

--

Dave Peterson


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

Label's caption is not assinged immediatly..
 

What toolbar did you use to get the label?

And post the portion of code that does the work.

abiram01 wrote:

The label is present on work sheet.

The message needs to be dispalyed is assigned but not displayed till
the task is completed.

Dave Peterson Wrote:
Is this label on a userform?

Look at RePaint and maybe DoEvents.

abiram01 wrote:

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

--

Dave Peterson

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

--

Dave Peterson