Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Position a user form next to selected cell
I have a macro which calls a user form
When the user form opens as the macro runs it is in the center of the screen..... is it possible to cause it to be positioned next to the selected cell. I see a "manual" choice in the form properties, I am not brilliant enough to figure how to make that setting work manually, much less with code. TIA for any help you have time to offer NWM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Position a user form next to selected cell
This code should work. You may want to add a little to the Left Position to
move it away from the cell LeftPos = ActiveSheet.ActiveCell.Left Wdth = ActiveSheet.ActiveCell.Width TopPos = ActiveSheet.ActiveCell.Top UserForm1.Left = LeftPos + Wdth UserForm1.Top = TopPos Userform1.show "nowhereman" wrote: I have a macro which calls a user form When the user form opens as the macro runs it is in the center of the screen..... is it possible to cause it to be positioned next to the selected cell. I see a "manual" choice in the form properties, I am not brilliant enough to figure how to make that setting work manually, much less with code. TIA for any help you have time to offer NWM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do set/ fix the opening position of a user form | Excel Discussion (Misc queries) | |||
Position selected cell | Setting up and Configuration of Excel | |||
How to I return the position of a selected cell in a range? | Excel Programming | |||
copy sheets selected on user form | Excel Programming | |||
copy sheets selected on user form | Excel Programming |