Toggling between userforms - remember userform moved position

[RawlinsCross]

I have 3 userforms that I toggle back and forth between. My problem is that each time I run the code UserformX.Show vbmodeless, the userform automatically re-centers on the screen. Is there any way to move back to the userform in a way where it remembers where it was?

 

[Fazza]

Untested. The userform has a deactivate event & an activate event: so store the left & top values when the cell deactivates & set them on activation.

 

[mikerickson]

In the Property Window, set the StartUpPosition to 0 (manual) and then set a .Top and .Left number for the start up position.

When the focus returns to the form via the .Show, it will remain in the place it was moved to.

 

[RawlinsCross]

Thanks Fazza and Mike - tried out the latter suggestion as it seemed most easily implementable although I do see advantages in the former. Mike's suggestion worked like a charm!