MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Center a picture on the screen (Is this posible??)


Posted by steve on April 14, 2001 9:05 AM

I'm trying to have a picture center itself in the active viewing section of the screen. My picture is linked to different ranges based on what cell is selected.
Any help would be great


Posted by Dax on April 14, 2001 9:37 AM

If your picture has been placed on an image control add this to your code once the picture is rendered.


Image1.Left = (ActiveWindow.Width - Image1.Width) / 2

Regards,
Dax.

Posted by steve on April 14, 2001 9:53 AM

Re: Center a picture on the screen (How do I add a picture on my screen to this??)

I'm guessing you mean the imagelist control, how do I add a picture thats on my sheet to it, it only excepts pictures from a file?
thanks steve

Posted by steve on April 14, 2001 10:49 AM

Re: Center a picture on the screen (can someone help)

The following code is what I have and it kind of works, but the picture only centers itself to the left of the work sheet. I need to have it center itself in the active visible area of the screen.
Thanks steve


Shapes("Picture 78").Left = (ActiveWindow.Width - Shapes("Picture 78").Width) / 2