Tuesday, 15 May 2012

How to use statusbar in excel vba on mac -


I am trying to install a progress bar so that I can see if my enterprise is running if I freeze Excel I'm looking at one of the answers, but it's not working.

Here's what I have:

set_cell_range = as the last name with the worksheets ("data_history") as an integer = N = 0 to 18 initial_grade_orange.offetset (n, 1) = end_are (n) application for range (find_last_column ("Data_History")). StatSbar = "Progress:" & amp; N & amp; "18" & amp; Format (n / 18, "0%") Next n Application. StatusBar = Wrong End

Is not it working because I'm on Mac?

I think you have an application.DisplayStatesbar and it is visible? Try adding DoEvents here:

  .... DoEvents application.StatusBar = "Progress:" & amp; N & amp; "18" & amp; Format (N / 18, "0%") ....  

No comments:

Post a Comment