UserForm positioning just below the specified cell

[hrayani]

Hello Friends,

I want the position of the userform to be as follows

1) Top position > Just below Cell C1
2) Left Position > Just next to Cell B2

As of now I am using this below code but the position get shaken when the screen is zoom out or zoom in

Private Sub UserForm_Initialize()
With Me
    .StartUpPosition = 0
    .Top = Range("C1").Top + 170
    .Left = Range("B2").Left + 50
End With
End Sub

Any help would be appreciated

Regards,

Humayun

 

[hrayani]

Finally with a lot of searching on the net I found a solution here

Help With Form Positioner

Hi Folks, I got the link below from previous posts people made here but having some difficulties. http://www.cpearson.com/excel/FormPosition.htm The link explains how to position your userform in a position of your choice. I have downloaded and imported the file, amended it to suit my...

www.mrexcel.com

Jaafar Tribak a well-known member of this amazing site has provided a solution on the above link