formatting rectangles on a form

cterjesen

Board Regular
Joined
Jun 23, 2003
Messages
119
I have a form with several items (buttons to run macros, text boxes to input data, labels with info and titles). I want to put a rectangle around certain items and color in the rectangle.

Whenever I color this in, the text boxes, buttons, etc. disappear behind the color. How do I get the color to be behind the labels, text boxes, buttons, etc.?

THANKS!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

bmacr

Board Regular
Joined
Jan 14, 2004
Messages
94
With your form in design view, you will find "Bring to front" and "Send to back" in the Format menu.
 

cterjesen

Board Regular
Joined
Jun 23, 2003
Messages
119
Thanks. That worked.

Can you tell me how to change the color of a command button and a message box?
 

bmacr

Board Regular
Joined
Jan 14, 2004
Messages
94
You can use a label as a button and you can change the colour of a label. You have to create the label from the toolbox though. The labels that are automatically created along with textboxes have no events available.

You can create your own custom message box just using a regular form with a button or two. Set the Pop-up, Modal, and Border Style properties as desired and the background colour. It will take a little more VBA code than a msgbox but not much.
 

Forum statistics

Threads
1,147,507
Messages
5,741,566
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top