Solved

Excel VBA Checkbox

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

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

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.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

630 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