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...
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!
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...
VBA Code:
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!