Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Positioning
Hi,
I looked on the posts but couldn't quite find what I was looking for. I'd like to position the top left of my userform at the top left of cell A1 or any cell I choose. Problem of course is the user form position coordinates are in relation to the screen and a cell's coordinates are in relation to the inside boundaries of the worksheet and I don't know the commands to get the absolute screen location of cell boundaries. Thanks much. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Positioning
See the code at http://www.cpearson.com/Excel/FormPosition.htm . This
allows you to position a form relative to a specified cell. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 14 Feb 2009 09:24:02 -0800, RLang wrote: Hi, I looked on the posts but couldn't quite find what I was looking for. I'd like to position the top left of my userform at the top left of cell A1 or any cell I choose. Problem of course is the user form position coordinates are in relation to the screen and a cell's coordinates are in relation to the inside boundaries of the worksheet and I don't know the commands to get the absolute screen location of cell boundaries. Thanks much. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Positioning
Thanks Chip, that's perfect.
"Chip Pearson" wrote: See the code at http://www.cpearson.com/Excel/FormPosition.htm . This allows you to position a form relative to a specified cell. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 14 Feb 2009 09:24:02 -0800, RLang wrote: Hi, I looked on the posts but couldn't quite find what I was looking for. I'd like to position the top left of my userform at the top left of cell A1 or any cell I choose. Problem of course is the user form position coordinates are in relation to the screen and a cell's coordinates are in relation to the inside boundaries of the worksheet and I don't know the commands to get the absolute screen location of cell boundaries. Thanks much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commandbar Positioning | Excel Programming | |||
Positioning | Excel Programming | |||
UserForm positioning to second row | Excel Programming | |||
UserForm positioning | Excel Programming | |||
= positioning | Excel Programming |