Hello, and thank you for your help.

I've been trying to figure out how to use Chip Pearson's FormPositioner code in my project but I'm not understanding how to make it work with my form or where to put his code or which parts I need to use. He has an example workbook with a "test" procedure that shows how the form can be positioned which uses a specific VBA module, modTest, I assume. The module contains some code, but not much and it doesn't appear to be calling the modFormPositioner module so I'm not understanding how they work together, if in fact they do at all.

Here's what I tried
  • Copied modFormPositioner to my project
  • Added the code he uses on modTest into the module that activates my form
  • Added the code from his form into my form
  • Changed references of VBA6 to VBA7
  • Changed all references of his form name to my form name.

Nothing changed at all for my form position and I don't get any errors. Nothing I do seems to affect my form position.

Ultimately, I want the form to be positioned just to the right of the active cell where the form was activated (with a double click) and aligned to the top of the active cell.

I just need to understand which parts of his code needs to go where, really. I think I can figure out the necessary modifications to position the form as I need it to be if I can just get it working at all.

Has anyone successfully been able to implement this into their own workbook and can you give me some insight of how to meld it into my project?

Thanks again. Please let me know if you need anything from me to help with this.