Excel Group Box Format

Posted on 2012-09-14
Medium Priority
Last Modified: 2012-09-17

I have a worksheet where I have drawn a Group Box on it. However I want to format the text to be bold & the borders a different colour. Is this possible? As the properties seem very limited. I am happy to use VBA if this is the only way to format the Group Box.

Ideally trying to copy to Frame that you would use on a useform.

Question by:mcs26
LVL 35

Accepted Solution

Norie earned 2000 total points
ID: 38401021
I don't think it's possible to change those properties of the Group Box.

I've looked through all it's properties and there's nothing there that works.

It's really just a container for other controls.

Have you tried using an ActiveX Frame?

Was that what you were referring to when you mentioned using VBA?

Author Closing Comment

ID: 38404829
Thanks for the reply imnorie.

I've decided to use an ActiveX Frame in the end. Believe your right in saying that you cannot change the properties I was trying to change.

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question