Hi,

I have already developed a Userform with the desired charachteristics.
But I want the userform to be positioned right adjacent to cell A 46,
no matter where I am on the page or where the screen is.

How can I do that? All Help is appreciated.


Thank You

put this into the code you have to show your form

ActiveWindow.ScrollRow = 35
ActiveWindow.ScrollColumn = 1

" wrote:

Hi,

I have already developed a Userform with the desired charachteristics.
But I want the userform to be positioned right adjacent to cell A 46,
no matter where I am on the page or where the screen is.

How can I do that? All Help is appreciated.


Thank You

I don't think this is that simple or ever foolproof, but have a look at
this:
http://cpearson.com/excel/FormPosition.htm

RBS

wrote in message
ups.com...
Hi,

I have already developed a Userform with the desired charachteristics.
But I want the userform to be positioned right adjacent to cell A 46,
no matter where I am on the page or where the screen is.

How can I do that? All Help is appreciated.


Thank You