0 votes
in VBA by Beginner (2 points)
I am french and a beginner in VBA .

I have created a macro that positions shapes and drop-down menus in specific areas of my active worksheet  display in full screen  (thanks to .Top, .Left, .Width and .Height of Shape properties)

When other people  launch this macro, the display is different depending on each screen (size, resolution, pixels per inch, ....) and so shapes are not put on the right places.


I am looking for a way to make my macro compatible with all computers.

1 Answer

0 votes
by Skilled (741 points)

My Excel Toolbox describes the M_DisplayScreen module, which has procedures for determining various display screen metrics. You should also review my Display Screen Size and Other Metrics tutorial.

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.