Position UserForm Relative to Cell

[Domenic]

Hi everyone,

I downloaded the sample workbook FormPositioner from Pearson's website.

First I replaced each occurence of VBA6 with VBA7 in the code.

Then I set the horizontal and vertical positions as follows...

HO = cstFhpFormLeftCellRight    '   set these to how you want the form positioned relative to AnchorCell
VO = cstFvpFormTopCellTop       '   set these to how you want the form positioned relative to AnchorCell

However, while the horizontal position is aligned correctly, the userform is positioned well below the target cell. The top of the userform should be aligned with the top of the target cell.

Am I missing something?

Anyone have any other code that would position the userform relative to a cell?

Thanks!

 

[Akuini]

Anyone have any other code that would position the userform relative to a cell?

See if this helps:

How do I align a UserForm next to the active cell?

I have a UserForm of a MonthView that opens when I click in the specified range of cells. This SO thread gave me the basic script. It doesn't put the UserForm where I expect. Here is the script (t...

stackoverflow.com

 

[Domenic]

Hi Akuini,

I tried the solution offered by Yin Cognyto in that link you provided, and it seems to work just fine. It works properly even when the worksheet is zoomed in or out, and when the worksheet is resized.

Thanks very much for your help, I really appreciate it.

Cheers!

 

[Akuini]

I tried the solution offered by Yin Cognyto in that link

You're welcome. I also use Yin Cognyto's code in an add-in I created, namely Search deList, which has been downloaded more than 2K times, and it works pretty well.

 

[Domenic]

Oh wow, that's great to know. Already my testing showed that it worked well. But it's definitely re-assuring that it has worked well for you.

Thanks again, I really appreciate!

Cheers!