Image Behind button

Mat · Sep 19, 2003

Hi,

I have a userform with 2 buttons and an image, and some other stuff not important for my problem.

The first button show the image :

Private Sub cbSchema_Click()
frmFAQ.Height = 250
cbRetour.Visible = True
imgSchema.Visible = True
End Sub

And the second buttons hide the image :

Private Sub cbRetour_Click()
frmFAQ.Height = 188.25
imgSchema.Visible = False
cbRetour.Visible = False
End Sub

Well my button cbRetour is supposed to be OVER the image, but now it is behind, so the user can't use it to go back...

How can I specify the order of the control?

Thank you

Mark O'Brien · Sep 20, 2003

You can use the ZOrder property of the control.

e.g. I set up a userform with an Image named "Image1" and two commandbuttons, "CommandButton1" and "CommandButton2"

This is the code I put in each of the commandbuttons, I think this is what you wat:

Code:

Private Sub CommandButton2_Click()
  CommandButton2.ZOrder 1
  Image1.ZOrder 0
  CommandButton1.ZOrder 0
End Sub


Private Sub CommandButton1_Click()
  CommandButton2.ZOrder 0
  Image1.ZOrder 1
  CommandButton1.ZOrder 1
End Sub

If this isn't exactly what you need, just repost.

Mat · Sep 22, 2003

Thank you Mark,

That's exactly what I needed!

Mat

Image Behind button

Mat

Well-known Member

Excel Facts

Mark O'Brien

MrExcel MVP

Mat

Well-known Member

Similar threads

Forum statistics

Share this page

Image Behind button

Mat

Well-known Member

Excel Facts

Mark O'Brien

MrExcel MVP

Mat

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock