Excel Group Box Format

Posted on 2012-09-14
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 33

    Accepted Solution

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now