Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have a userform is Height = 220 and Width = 312. By default, this userform will pop up in the centre of the window.
In my code, this userform expands to a width of 432, and the height remains unchanged.
I am looking for a VBA solution to recentre the userform based on its new size. One factor that will need to be considered is that the Excel VBA application I'm working on will be used on different sized monitors, so fully a solution can be shared that will compensate for that.
In my code, this userform expands to a width of 432, and the height remains unchanged.
I am looking for a VBA solution to recentre the userform based on its new size. One factor that will need to be considered is that the Excel VBA application I'm working on will be used on different sized monitors, so fully a solution can be shared that will compensate for that.