In VBA, I have a simple statement to display a form when a certain worksheet
is selected:

Private Sub Worksheet_Activate()
frmMyform.Show
End Sub

But when the form appears, it always appears on the second monitor. It
doesn't matter which monitor is showing the worksheet. Furthermore, even
though both form.top and form.left are zero, the form appears up against the
left edge of the monitor as expected (although the wrong monitor), but
centered vertically.

How can I put the form where I want it?