Anchor a Userform to a cell in the worksheet
 

How can I anchor a user form to a specific cell on the worksheet? I tried
to use the .top and .left properties for the user form. But, when a
different screen resolution is used, the user form appears in a different
place. Thanks in advance.

--
Bob Kaku
Email:
http://www.majesty.org

Anchor a Userform to a cell in the worksheet
 

http://www.cpearson.com/excel/FormPosition.htm
See this Webpage Bob

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Bob Kaku" wrote in message news:csN4b.244367$cF.78468@rwcrnsc53...
How can I anchor a user form to a specific cell on the worksheet? I tried
to use the .top and .left properties for the user form. But, when a
different screen resolution is used, the user form appears in a different
place. Thanks in advance.

--
Bob Kaku
Email:
http://www.majesty.org

Anchor a Userform to a cell in the worksheet
 

Chip,

Thanks a lot. I had a little difficulty understanding the code at first.
But, then I got. It works like a charm.

Bob Kaku
"Chip Pearson" wrote in message
...
Bob,

See http://www.cpearson.com/excel/formposition.htm for details and
downloadable code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Bob Kaku" wrote in message
news:csN4b.244367$cF.78468@rwcrnsc53...
How can I anchor a user form to a specific cell on the worksheet? I
tried
to use the .top and .left properties for the user form. But, when a
different screen resolution is used, the user form appears in a
different
place. Thanks in advance.

--
Bob Kaku
Email:
http://www.majesty.org