Solved

Excel VBA Checkbox

Posted on 2014-12-22
3
186 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 total points
ID: 40514128
In VBA you can use:

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

749 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