Allow userform to follow cells possible?

[ShieBoon]

Hi all, I have a userform which starts up at a particular position (at Row 1) whenever a worksheet is loaded, which purpose is to provide better user experience.

But because of smaller screen sizes such as the laptop, the userform appears at the top of the screen, covering the buttons. Is there a way i can allow the userform to follow Row 1, be it a laptop or a desktop?

Excel 2003

Thanks
Shie Boon

 

[Tom Urtis]

What do you mean, "follow row 1"? Where does row 1 ever go?

 

[VoG]

See if this helps http://www.cpearson.com/excel/FormPosition.htm

 

[ShieBoon]

Tom: Because the users may have different computers, such as laptops or desktops, thus having different screen sizes. i coded my userform to appear at the top left hand corner of the screen.

I am using a desktop to do my coding, thus for desktops like mine the userform should appear at the right position.

However when i went home afterwards to open up the program in a laptop, the userform appeared on the buttons on the ribbon of excel. Thus i want a method to ensure the userform follows row 1, to not block the buttons on the ribbon.

Vog: I will. Thanks.