+1 vote
in VBA by Beginner (8 points)


I have another question regarding the tutorial https://wellsr.com/vba/2017/excel/beautiful-vba-progress-bar-with-step-by-step-instructions/.

The progressbar is working flawlessly.  However, when using a dual screen setup, I see the following:

  • When the Excel workbook runs on the main screen (primary monitor, located on the right) then the progress bar is nicely centered in the middle of the Excel sheet when running, whatever the size of the Excel workbook (full screen or reduced view)
  • But when the Excel workbook is running on the secondary screen then the progress bar is locked against the left side of the primary (right) monitor, like shown in the picture below:

    Progress bar is blocked at side of screen.

    The green square represents the secondary (left) monitor, the red square represents the primary (right) monitor.
  1. What's the reason the progress bar is blocked on the primary screen and doesn't appear on the secondary screen?
  2. Is there any way to get the progress bar always in the middle of the Excel workbook, whatever the location of the workbook?


1 Answer

0 votes
by Beginner (12 points)
Voce tera que determinar em qual ecra deve aparecer a barra do progresso, ou entao altera configuracao  da apresentacao do ecra
by Beginner (8 points)
Well, this is not exactly the answer I'm expecting to see.

I can't force the user of my spreadsheet to make sure the spreadsheet is on the main display.  Nor can I for sure not asking her/him to change the screen settings.  This is a user-unfriendly solution.

I know there's some "magic" used in the example progress code in this sample by using specific Windows API's but I'm too unfamiliar with them to see a solution for the problem...

Welcome to wellsr Q&A
wellsr Q&A is the VBA and Python programming community that rewards you for learning how to code.

Getting Started
VBA Cheat Sheets (On Sale Now)

Earn free prizes for asking VBA and Python questions and for answering questions asked by others in our community.

Looking for something else? Hire our professional VBA Help, instead.

What makes us different?
Our points system rewards you with a chance for free gifts based on the quality of your questions and answers. All you have to do is post and you could get rewarded, like these members:

ParserMonster $25 Amazon Gift Card
Hightree $10 Amazon Gift Card
Thales1 $10 Amazon Gift Card
runfunke $10 Amazon Gift Card
coolag $10 Amazon Gift Card
Siew Hun $10 Amazon Gift Card

So, why don't you join us? It really is an encouraging way to motivate members in our VBA and Python community.


For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.