Appears to be necessary to have the coded UserForm default of StartUpPosition be CenterOwner, so that on the initial load the form appears in the center of the Excel window.
However, after the initial .Show it should probably be changed to Manual so that it doesn't keep re-appearing in the screen real estate the user is likely trying to use.
Appears to be necessary to have the coded
UserForm
default ofStartUpPosition
beCenterOwner
, so that on the initial load the form appears in the center of the Excel window.However, after the initial
.Show
it should probably be changed toManual
so that it doesn't keep re-appearing in the screen real estate the user is likely trying to use.