Userform Position exactly adjacent to Cell A 46

[rachitm]

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

 

[Guest]

put this into the code you have to show your form

ActiveWindow.ScrollRow = 35
ActiveWindow.ScrollColumn = 1

 

[RB Smissaert]

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

RBS