Solved

Excel VBA Checkbox

Posted on 2014-12-22
3
177 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 500 total points
ID: 40514128
In VBA you can use:

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

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
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…

910 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

22 Experts available now in Live!

Get 1:1 Help Now