moving pictures to the back excel 2010 - Xtreme Visual Basic Talk

12-10-2010, 12:10 PM

rwandamark rwandamark is offline

Newcomer

Join Date: Dec 2010

Posts: 1

moving pictures to the back excel 2010

Hi, I am relatively new to VBA in Excel 2010.
I have 4 logos strategically placed on top of one another.
When the user clicks the logo, I want to send it to the back, so that the one underneath will show up, and so one.
Can you direct me as to do this? I appreciate your details and assistance.

Thank you!
Mark

12-10-2010, 03:22 PM

Colin Legg

Out Of Office

Retired Moderator
* Expert *

Join Date: Mar 2005

Location: London, UK

Posts: 3,398

Welcome to the forum, Mark.

Sending a picture to the back is quite straightforward because the Picture class has a SendToBack method. The trick to this is being able to use a single procedure which can be assigned to all four logos: to do this you have to know which picture has been clicked. This can be done using Application.Caller.

Say the codename of the sheet is Sheet1. In a standard code module place this code:

Code:

Sub SendLogoToBack()

    Dim picLogo As Picture
    
    Set picLogo = Sheet1.Pictures(Application.Caller)
    
    picLogo.SendToBack
    
End Sub

Assign this procedure to all four logos and then you should be up and running...

__________________
RAD Excel Blog

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules