| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you anchor an image to a cell in excel? | Excel Worksheet Functions | |||
| How Do You ANCHOR a Cell Reference? | Excel Discussion (Misc queries) | |||
| anchor comments to cell while inserting and deleting rows | Excel Discussion (Misc queries) | |||
| How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
| How do I anchor a cell/create absolute ref. while clicking on it? | Excel Worksheet Functions | |||
Linear Mode
