Place TextBox Behind Other Controls on a Workshheet

M

Minitman

Greetings,

I am using a TextBox as a back ground. I have done this in a UserForm
to color a MultiPage control by setting the display order>Send to back
or Bring to front with ZOrder. I don't see that command available for
a Control Toolbox Label.

Can anyone show me how to put this Control Toolbox Label behind other
controls (CommandButtons)???

Any help will be appreciated.

-Minitman
 
P

Peter T

In design mode right click the control and look at Order.

Adapted from the macro recorder -

ActiveSheet.Shapes("Label1").ZOrder msoSendToBack

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Programable Controls on a Chart 2
Excel forms - hiding a group of controls 0
Controls inside a Frame do not display in design order. 2
How do I create a TextBox on a DialogSheet in VBA? 1
Bug ! Textbox on userform will not align text correctly ? 2
Formula in userform textbox 1
Visible = True - Not Working 4

Top