Position Userforms on the Right Hand Side of screen

**ben_patto** · 09-15-2009, 07:31 AM

Hello,

I want a userform to pop up on the RIGHT side of the screen. I have 10 Columns of data on the left, and want the user to be able to see all of it, while the userform is displayed.

When programming the form, the dimensions can be manually input to set the form to appear in co-ordinates from the top and the left of the screen. Thus, If I set the form to a suitable position near the right hand scroll on my screen (14" laptop screen) when the file is opened on a 17" screen the form will not be on the right hand side of the screen near the scroll.

Any ideas?

Cheers

**Andy Pope** · 09-15-2009, 07:35 AM

Check Chip's page
http://www.cpearson.com/Excel/FormPosition.htm

**ben_patto** · 09-16-2009, 12:40 AM

Very useful site, thou everything is referenced from the left and top side of the screen. I will work around the problem. thanks anyway!

**shg** · 09-16-2009, 01:10 AM

I think all object positions in Excel are referenced from Left and Top. That, combined with window width and height and form width and height, should get you what you need.