SerenityNetworks
Board Regular
- Joined
- Aug 13, 2009
- Messages
- 131
- Office Version
- 365
- Platform
- Windows
I have a user form that displays images. In my case, the bigger I can display the images the better it will be for the user. If I scale the user form for the display on my laptop's monitor then when I choose to use a larger external monitor the images are not nearly as large as the monitor is capable of displaying. I'd like to be able to manipulate the size of the user form, and the size and position of different elements within the user form. Is there a way to do this from within Excel, or using fields or buttons on the user form itself? For example, I could have an 'increase width' button on the user form. Clicking it would increase the width of the user form 'n' pixels. I could also have a corresponding button to decrease the width of the user form, and buttons to increase and decrease the height. If manipulating the form by using buttons on the form isn't feasible then could it be done using values in an Excel worksheet? I'm open to any option that lets me resize the user form and some of the elements in the form.
I've placed an example of the workbook here. (In this example I've trimmed out a bunch of code for other fields and functions and just left the basics.)
Any help will be greatly appreciated.
Thanks in advance,
Andrew
I've placed an example of the workbook here. (In this example I've trimmed out a bunch of code for other fields and functions and just left the basics.)
Any help will be greatly appreciated.
Thanks in advance,
Andrew