| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the space used for my x-axis labels | Charts and Charting in Excel | |||
| Worksheet Column Labels ... Alphabet or Numeric ? | Excel Discussion (Misc queries) | |||
| Force bar chart x-axis labels to two lines? | Charts and Charting in Excel | |||
| Charts - Align value & category data labels independently | Charts and Charting in Excel | |||
| Excel2003: Axis labels are truncated | Charts and Charting in Excel | |||
Hybrid Mode
