Code Samples for Businesses, Schools & Developers

First Published 28 Oct 2026



This is a companion to my recent article: Message Box with Position & Zoom

Like the standard VBA message box, input boxes are always centred on the screen, have small font size (8pt?) and cannot be zoomed (other than by using Windows scaling).

With modern monitors and typical resolutions of 1920 x 1080 or higher, the text can be difficult to read comfortably, even for users whose eyesight is reasonably good.

The centred positioning can also mean that users often need to move the message box to one side before acting on its contents.

The InputBoxPZ (position/zoom) function overcomes both of these issues by allowing developers/users to control where a input box opens and to adjust its zoom level.

This project was started by my colleague Xevi Batlle with the assistance of Gemini/Antigravity AI.

I then further modified the functionality to allow the input box to be docked to specific positions on the screen.



The InputBoxPZ function



DETAILS COMING SOON!







Related Article

A very similar function called MsgBoxPZ can be used to enhance/replace the standard MsgBox function by adding the same additional positioning and zoom functionality.

See my article: Message Box with Position & Zoom



Feedback

Please use the E-Mail button in the contact form below to let me know whether you found this article useful or if you have any questions.

Please also consider making a donation towards the costs of maintaining this website. Thank you


Colin Riddington Mendip Data Systems Last Updated 28 Oct 2026




Return to Code Samples Page




Return to Top