I have macro which runs through 10000 rows,
I would like to have msgbox showing the row numbers, but it should not
have ok buttion.
Just showing only the row numbers till macro is running.

Is this is possible

I have excel 2007.

Thanks

Hi,

You would probably need a userform to do that but why not use the statusbar
by putting a line like this in your code

Application.StatusBar = "Working on row " & x

Mike

" wrote:

I have macro which runs through 10000 rows,
I would like to have msgbox showing the row numbers, but it should not
have ok buttion.
Just showing only the row numbers till macro is running.

Is this is possible

I have excel 2007.

Thanks

Hi,

Agree with Mike's suggestion or, if you want to display something, use a
userform and update a label on the form like

formname.okbutton.visible=false
formname.statuslabel.caption = "Working on row " & x

And then when you're done, display that you're done and a button to
close the form

formname.statuslabel.caption = "Done - processed " & x & " rows"
formname.okbutton.visible=true

Christoph

Mike H wrote:
Hi,

You would probably need a userform to do that but why not use the statusbar
by putting a line like this in your code

Application.StatusBar = "Working on row " & x

Mike

" wrote:

I have macro which runs through 10000 rows,
I would like to have msgbox showing the row numbers, but it should not
have ok buttion.
Just showing only the row numbers till macro is running.

Is this is possible

I have excel 2007.

Thanks

Thanks Mike


Mike H wrote:
Hi,

You would probably need a userform to do that but why not use the statusbar
by putting a line like this in your code

Application.StatusBar = "Working on row " & x

Mike

" wrote:

I have macro which runs through 10000 rows,
I would like to have msgbox showing the row numbers, but it should not
have ok buttion.
Just showing only the row numbers till macro is running.

Is this is possible

I have excel 2007.

Thanks- Hide quoted text -

- Show quoted text -