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

 

[dmt32]

Hi,
Have a read here: Form Positioner

and see if helps you - you can download the sample workbook

Dave

 

[hrayani]

Hi Dave,

I downloaded the file... There is a lot of stuff out there. Will take some time to test that out...

What I have done now is I have set the position of the userform with screen zoom 100 % and before calling the userform I have set the zoom level to 100%.

Thanks for the reply,

Regards,

Humayun

 

[hrayani]

Hi Dave,

I tested the file to the best of my understanding but unable to make it work.

The user form changes its position when the screen zoom level changes - thus does not stick to cell.

Any idea ??

I want the userform to stick to a cell no matter what the screen size is or headings are displayed or not or its a full screen or not....

 

[dmt32]

Sorry not my code or one I have used - unless another is familiar with it, suggest you contact the author on his site.

Dave

 

[hrayani]

Thanks anyways dave

I will wait for the experts out here. Hopefully I will get a solution to it

 

[Fluff]

suggest you contact the author on his site.

Unfortunately that will be difficult, Chip died a couple of years ago.

 

[hrayani]

Unfortunately that will be difficult, Chip died a couple of years ago.

Sad to hear that

 

[dmt32]

Unfortunately that will be difficult, Chip died a couple of years ago.

Thanks @Fluff - no idea of that - sad loss to excel community.

Dave

 

[Fluff]

Agreed, a very big loss.