Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel VBA Checkbox

Posted on 2014-12-22
3
Medium Priority
?
223 Views
Last Modified: 2014-12-23
I have a checkbox in excel vba, how do i change the label font size in the checkbox to make it larger then the default.
0
Comment
Question by:macone1976
  • 2
3 Comments
 
LVL 3

Expert Comment

by:Glenn M
ID: 40514105
There isn't an easy way to change the formatting of a form check box - you can use an ActiveX check box instead and do anything you'd like with appearance to that.

There is a hard way; http://www.jkp-ads.com/Articles/Excel2007FileFormat01.asp
0
 
LVL 22

Expert Comment

by:Flyster
ID: 40514108
In design mode. right-click the checkbox and select properties. Select Font and change Font, Style and size there.

Flyster
0
 
LVL 22

Accepted Solution

by:
Flyster earned 2000 total points
ID: 40514128
In VBA you can use:

Me.CheckBox1.Font.Size = (Enter numerical value here)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

606 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