form location on sworksheet
 

is there a way to have a form open at a specific location relative to a
worksheet ex, with it's top corner at cell B23 (not relative to the screen?)

-thanks, mark

form location on sworksheet
 

To my knowledge there are four settings:

Manual 0 No initial setting specified.
CenterOwner 1 Center on the item to which the UserForm belongs.
CenterScreen 2 Center on the whole screen.
WindowsDefault 3 Position in upper-left corner of screen.




"mark kubicki" wrote:

is there a way to have a form open at a specific location relative to a
worksheet ex, with it's top corner at cell B23 (not relative to the screen?)

-thanks, mark

form location on sworksheet
 

You might play with this code on Chip Pearson's site.
http://www.cpearson.com/excel/FormPosition.htm

--
Regards,
Tom Ogilvy

"mark kubicki" wrote in message
...
is there a way to have a form open at a specific location relative to a
worksheet ex, with it's top corner at cell B23 (not relative to the
screen?)

-thanks, mark