Anchor a form to a specific cell

Thanks shg. Here's how I applied it:

Please Login or Register  to view this content.

But it had no effect, regardless of how I set the form's StartUpPosition property. The form appeared at the very top left of the screen, not at A1 of the worksheet. Did I apply the code wrong, or put it in the wrong place? The sub is in a code module, not the form module.

I'm working in Excel/VBA 2003, because that's what my client uses. Also, many of his clients who will use this app will have 2003 or earlier. StartUpPosition 3 on my system is Windows Default, and there is no setting for position in UL corner - wish there was.

Thanks RoyUK,
Pearson notes that what I want to do is not all that simple. But he offers two solutions, including sample files. One is for modeless forms, which is what I want. It involves an API call to make the form a child of the worksheet window. It will be another day or so before I can start working on it; but it should be a good education.

I've seen (and saved) some other Excel/VBA dissertations by Pearson. He presents the material quite well.

Thanks RoyUK,
CPearson' s FormPositioner works, and I'm adapting it to my application. But it contains something completely new to me, namely: #If #Else #EndIf statements. These statements do not appear inside a procedure. In all cases they set various declarations and enums, depending on "VBA6" or not. My version of VBA is 6.5.1053 (Excel 2003).

I've never encountered this before. Some Googling raised some references for C and C++, suggesting that the # prefix indicates conditional compiling, which sorta makes sense. But I could find nothing (including CPearson's site) that specifically addressed its use in VBA. I'd like to know more about this new-to-me subject before I incorporate it into my application. Can you (or anyone else) point me in the right direction?

Thanks

That's just the info I was looking for. Thanks for everyone's help on this topic, I'll mark it as solved.