Status Bar = Format(fraction Done, "0%") & " done..." ''// or, alternatively: ''// status Range.value = Format(fraction Done, "0%") & " done..." ''// Some code....... Display Status Bar = boo Status Bar State ''//Reset Status bar display setting Application.
Status Bar = False ''//Return control of the Status bar to Excel Application.
I have found an article on this subject but I can't quite get my head around how to implement the answer proposed.
What I am getting is a cross-thread exception and I realise that the GUI is in one thread and the worker is in another thread. Invalid Operation Exception was unhandled by user code HResult=-2146233079 Message=Cross-thread operation not valid: Control 'list Box Codes' accessed from a thread other than the thread it was created on.
Worker Thread Start(Object argument) Inner Exception: using System; using System.
en_US#na) [Help & Support 🔧]( [Report A Bug]( [Client Discussion]( This board is the best place to discuss the client with Rioters and your fellow players, although it won't be our main source for feedback resolution. Send Message(Int32 msg, Int32 wparam, String lparam) at System. My Thread.background Worker_Do Work(Object sender, Do Work Event Args e) in D:\My Programs\Find Duplicate MX codes\Find Duplicate MX codes\My Thread.cs:line 69 at System. But since that only concerns the new-style sheet-metal parts I have some question for which I hope to find some answers here: The main goal here is that when the code gets really fast, it would be an option for me to run the code on every rebuild automatically, instead of having the users to run the macro manually. My Excel tool performs a long task, and I'm trying to be kind to the user by providing a progress report in the status bar, or in some cell in the sheet, as shown below.