I have recently developed an Excel-based analytical tool that is designed to share the desktop.  The tool provides the functionality to position the Excel window either on the left or right side of the desktop, occupying about 1/2 of the screen.

For this tool, there are several userforms used that are positioned within the Excel window, respecting the left / right orientation when used, with the potential for several userforms to be open at the same time.  I felt that the aesthetics for userform presentation was just not right initially because when the standard Msgbox prompts were issued, these would appear in the centre of the screen, rather than the userform to which the prompt referred.

Continue Reading: MsgBox Centred Over a Userform »