Msgbox Without ok button

  • Thread starter Thread starter fi.or.jp.de
  • Start date Start date
F

fi.or.jp.de

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
 
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
 
Back
Top