View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Kaku Bob Kaku is offline
external usenet poster
 
Posts: 7
Default 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