Refresh Form / Text box

[JAZPpl]

Hello Everybody,

I am running a code which takes a couple of minutes to compute and I would like the user to see what is going on. I want to avoid to put a process bar as I know it will slow the code even more.
I have put an application.StatusBar with one of the loop but the form is automtically open using Sub Auto_open() and xl is minimized.
So I created a text box which links to one of the value of the counter but it doesn't update automatically.
How could i do that ?


so far in the main code I have

For i = 0 To Datapoint - 1
ApplicationStatusBar = i
Sheets("LogFile").Range("T20") = i
'in the main form I have created a textbox which control
' source is LogFile!T20

Application.ScreenUpdating = False


Help would be greatfully appreciated.

Thankxx

 

[Chance1234]

Application.ScreenUpdating = False ' thats why !

Chance,

Filmmaker, gentlemen and explorer

http://WWW.HOWTOBESPOOKY.CO.UK

 

[JAZPpl]

I took it out and it still the same (see code below)

For i = 0 To Datapoint - 1
'ApplicationStatusBar = i
'Sheets("LogFile").Range("T20") = i

'Application.ScreenUpdating = False

The content of the text box only appears when the I use Ctrl+Break

f,

 

[JAZPpl]

JAZPpl (TechnicalUser) Sep 9, 2004
I took it out and it still the same (see code below)

For i = 0 To Datapoint - 1
'ApplicationStatusBar = i
Sheets("LogFile").Range("T20") = i

'Application.ScreenUpdating = False

The content of the text box only appears when the I use Ctrl+Break

f,

 

[Chance1234]

When you are saying textbox , is this a textbox on a form or , linked to a sheet ?

Chance,

Filmmaker, gentlemen and explorer

http://WWW.HOWTOBESPOOKY.CO.UK

 

[JAZPpl]

yes it is

f,

 

[Chance1234]

which one ?

Chance,

Filmmaker, gentlemen and explorer

http://WWW.HOWTOBESPOOKY.CO.UK