Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find top of worksheet
I've added a form to my spreadsheet. I'd like it to start
at the top right hand corner of the spreadsheet. How can I find the value for "UserForm.Top" regardless of the number of toolbars the user has shown and regardless of if the row and column headers are displayed? I've tried the following: UserForm.Move 584, ActiveSheet.Cells(1).Top but this puts the form way up in the title bar/tool bars area. Thanks! Debbie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find top of worksheet
http://www.cpearson.com/excel/FormPosition.htm
Check out this site -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "D. McDonough" wrote in message ... I've added a form to my spreadsheet. I'd like it to start at the top right hand corner of the spreadsheet. How can I find the value for "UserForm.Top" regardless of the number of toolbars the user has shown and regardless of if the row and column headers are displayed? I've tried the following: UserForm.Move 584, ActiveSheet.Cells(1).Top but this puts the form way up in the title bar/tool bars area. Thanks! Debbie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find tab in worksheet | Excel Discussion (Misc queries) | |||
how to find and unlink current worksheet from old worksheet | Excel Discussion (Misc queries) | |||
Find worksheet | Excel Discussion (Misc queries) | |||
Find Max Value in WorkSheet | Excel Worksheet Functions | |||
How Do I Find A Specific Worksheet | Excel Discussion (Misc queries) |