userform position

How can userform be positioned so that Top Left Hand corner is at Top Left corner of cell B2. It should work when window is maximized or restored. This doesn't seem to work. Private Sub UserForm_Initialize() Me.StartUpPosition = 0 Me.Top = Range("A1").Top + Range("A1").Height...

The useform startup position doesn't seem to take into account of the ribbon. I couldn't find a way to test if the ribbon was minimized or not. Tried to position relative to first row, but this still considers the ribbon, same position results if ribbon is minimized or not. Private Sub...

I downloaded a Userform that is a Calendar that that is portable. This can be downloaded here: Excel VBA Date Picker I am using an external monitor as an extended screen. I have the following code in the Worksheet Selection Change area of code: If Not Intersect(Target, Range("B5")) Is Nothing...

It appears that when a userform's startup position property is set to Manual, the position of the form is relative to the selected cell, but only in terms of the cell's position relative to A1. I could select a cell such as AC8, which means that A1 would not be visible, but form pops up as if A1...

I have a few userforms that you can click on buttons and to move back and forth using hide and show. here is the problem: Your on UF1 and click the button and go to UF2. Then you move that window, and click a button back to UF1 the window jumps. Move either window and you end up clicking...