Every article I've found says that this should work:
The form shows up on the top left of the screen regardless of whatever number I use for .Top and .Left.
Please Login or Register to view this content.
In the attached, click on any of the plus signs on in columns C or D.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Entia non sunt multiplicanda sine necessitate
I get the error message: Compile error" User-defined type not defined on
Dim PS as Position.
Also I don't see where cstFvpauto an cstFhpAuto are defines and where the Function PositionForm is defined.
I see it now. Now I need to define it relative to a fixed cell.
Now I want the form to come up so that the top is on the target row and left is on Column M.
How would I modify this code?
Please Login or Register to view this content.
Sorry, I don't think I've ever used the code. But if Chip Pearson did it, you know it's golden.
Try this modification
Please Login or Register to view this content.
Chip's page is one of my go to resources for things Excel. Thanks for the tip Andy, but it did not seem to help.
I decided to strip away everything else and create a workbook with only the form and the code. Horizontally, it seems to work. However, I noticed the following on the vertical position. If I expand the formula bar, the form shows up three rows below the selected cell. If I collapse the formula bar, the form shows up 4 rows below the selected cell. Similarly, it changes vertical position relative to the cell if I expand or collapse the ribbon. It ALWAYS appears in the same vertical position on the screen or at least as far as these old eyes can recon it.
Select a cell and click the button.
Please Login or Register to view this content.
That code dates back to 2002 and a lot of it uses the commandbars to calculate positions, as well as assuming (as noted in the comments) that the formula bar is the same height as the main menu bar. Obviously, post 2003 much of that is fallible!
For practical purposes, it comes out close enough and I can live with it. However, it does seem to be a lot more complicated than it has to be. Too bad we don't have something like "The screen begins at 0, 0 but the display begins at X, Y.
There were much simpler ways in 2003 and earlier. My preference was to create a 0x0 chart, activate it to get the chart window co-ordinates and then delete it. You could then position the userform using those coordinates. Unfortunately, the chart window no longer exists, so that approach is, so to speak, out the window.
It makes you wonder why everything else is relative to the grid except user forms.
Userforms aren't locked to the grid in any way, or even to the application window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks