{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Deceive 欺骗 的问题《Application.Statusbar not working as expected in E》','https://www.manongdao.com/q-425050.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I have an application that uses Application.Statusbar to update the status bar with progress of the macro. This works fine in Excel 2007 and 2010 but it doesn't display correctly in Excel 2013.
The application executes correctly but the status bar is not updated.
Any ideas appreciated.
Thanks Siddharth. The DoEvents hint was what i needed. I have never needed it for Excel 2007 or 2010 but something must have changed in 2013 so that I need to yield control.
Have added DoEvents and now works fine.