<div>
Hi both,<br />
<br />
Thank you for the replies. &nbsp;<br />
<br />
1) obtaining the screen resolution - that is great and is working fine;<br />
<br />
2) I will modfiy / &nbsp;incorporate a code to execute the following:<br />
&nbsp; &nbsp; if resolution is &lt;=800, then &nbsp;me.zoom = 75 <br />
&nbsp; &nbsp; if resolution is &lt;=1066, then me.zoom = 85 <br />
&nbsp; &nbsp; if resolution is &lt;=1366, then me.zoom = 100 .........<br />
* &nbsp;( since I am using Excel &nbsp;<b>userforms </b>)<br />
<br />
<br />
Wll revert with the results. <br />
<br />
Many thanks and regards
</div>


Hi both,

Thank you for the replies.  

1) obtaining the screen resolution - that is great and is working fine;

2) I will modfiy /  incorporate a code to execute the following:
    if resolution is <=800, then  me.zoom = 75
    if resolution is <=1066, then me.zoom = 85
    if resolution is <=1366, then me.zoom = 100 .........
*  ( since I am using Excel  userforms )


Wll revert with the results.

Many thanks and regards

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Is there an Excel &nbsp;VBA code that I could query the screen resolution of a laptop &nbsp;( e.g. 1366 x 768 ) &nbsp;when I fire up a workbook from it ?<br />
<br />
Is so, would appreciate your help with the vba code.<br />
<br />
<br />
Thanks
</div>
</div>


Hi,

Is there an Excel  VBA code that I could query the screen resolution of a laptop  ( e.g. 1366 x 768 )  when I fire up a workbook from it ?

Is so, would appreciate your help with the vba code.


Thanks

Excel VBA - Query for Screen Resolution of a Laptop

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.