ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   update Label and other component (https://www.excelbanter.com/excel-programming/320883-update-label-other-component.html)

Maileen[_2_]

update Label and other component
 
Hi,

I have a task which scan a sheet and especially which calculate the
amount of records.

for that, i have a Label which should be updated in permanence to
display the % already scanned.
however, my form only display 2 status.
the initialization to 0 and when it's done at 100 %.
how can i my the form update the label every time that it should normaly
be done.

something like :

initialization -- 0 % done
after xxx records scanned -- xxx % done
after yyy records scanned -- yyy % done
when it's finished --< 100 % done.

thanks for help.

Maileen

Maileen[_2_]

update Label and other component
 
Just some precision...
if i use myform.repaint, it fix the problem, but myform is blinking due
to painting. :(


Maileen wrote:
Hi,

I have a task which scan a sheet and especially which calculate the
amount of records.

for that, i have a Label which should be updated in permanence to
display the % already scanned.
however, my form only display 2 status.
the initialization to 0 and when it's done at 100 %.
how can i my the form update the label every time that it should normaly
be done.

something like :

initialization -- 0 % done
after xxx records scanned -- xxx % done
after yyy records scanned -- yyy % done
when it's finished --< 100 % done.

thanks for help.

Maileen


Tom Ogilvy

update Label and other component
 
Make sure screenupdating is not set to false and put in DoEvents where you
now have the Repaint. See if that works.

--
Regards,
Tom Ogilvy


"Maileen" wrote in message
...
Just some precision...
if i use myform.repaint, it fix the problem, but myform is blinking due
to painting. :(


Maileen wrote:
Hi,

I have a task which scan a sheet and especially which calculate the
amount of records.

for that, i have a Label which should be updated in permanence to
display the % already scanned.
however, my form only display 2 status.
the initialization to 0 and when it's done at 100 %.
how can i my the form update the label every time that it should normaly
be done.

something like :

initialization -- 0 % done
after xxx records scanned -- xxx % done
after yyy records scanned -- yyy % done
when it's finished --< 100 % done.

thanks for help.

Maileen





All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com