Solved

Excel VBA Checkbox

Posted on 2014-12-22
3
180 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

813 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

9 Experts available now in Live!

Get 1:1 Help Now