Free Microsoft Excel 2013 Quick Reference

Changing the size of checkbox

Hi All:

I created an excel sheet with comboboxes with size 20 fonts. In order to
view the excel sheet well I have to set the zoom view to 50%. However, I
also needed to add some checkboxes. At 50% zoom the checkboxes look tiny. I
tried putting checkboxes through control toolbox and the forms menu, but I
cannot change the size of the box itself, only the font. Is there a way I can
do this or another control that would allow me to resize the checkbox ?

Thanks for your help,


I have inserted a calender in my spreadsheet that controls the data which is entered in that cell and appears only when that particular cell is selected. However, the calendar appears small and unreadable. I have altered the code to resize the calendar to an appropriate size but does not work the first time the cell is selected for obvious reasons.

The code, that changes the size of the calendar, needs to be placed in "Microsoft Excel Objects, This Workbook" to run when the workbook is opened. I cannot find the correct code for this to happen.

Any help would be appreciated.

How can i change the size of a form control check box? I can change the size
of the control but not the size of the actual square.

How do I change that size?


I have Office XP Professional 2002. When using 'forms' tool batr I try to
change the size of the actual check box via format control and nothing
happens - only the bigger "defined" area around it. Move and size with cell
also is not offered as an option (it remains shaded)

Spinners by contrast DO allow a % size change or mm size change or via cell

How can I change the actual check box in a similar way to Spinners?



Thanks anyway Jon,

I am entirely too buried under 3 major contracts to play around with this
anymore. For the time being I'll just use PDFs that I CAN create without a
whole lot of hoop-jumping. I'll have to format a template set that will do a
standard 800X600 browser window but at least I won't have to play with this
Excel issue as well as some other PowerPoint workarounds I need to do.
One of my consultants (UNIX guy) suggested I take a look at Star Office
which is supposed to be able to read and write .ppt files and most other MS
formats. In addition it runs on just about every platform and costs about $40.
Probably not good talking about other software here but I can't tell you the
huge amount of time I've wasted trying to get this process automated....

THX again,


"Jon Peltier" wrote:

> Doc -
> Yes, this is certainly frustrating. And it means more work.
> Using VBA you can measure the position of each data label (its .Top and .Left). It's
> a little trickier, but you can also determine the position of the center of each
> data label (not just algebra, because Excel won't tell you how tall or wide it is).
> If interested, post back and I'll describe how to do this.
> Then you can do a few nested loops (pseudocode):
> For each ws in activeworkbook.worksheets
> For each chtob in ws.chartobjects
> for each srs in chtob.chart
> For each dl in srs.datalabels
> ' code to get centers of dl
> ' dlHcenter, dlVcenter
> set txt = activechart.Shapes _
> .AddTextbox(msoTextOrientationHorizontal, _
> 100, 100, 200, 50)
> ' dummy temp dimensions (points)
> with txt
> .AutoSize = True
> .TextFrame.Characters.Text = _
> dl.text
> .left = dlhcenter - .width/2
> .top = dlvcenter - .height/2
> end with
> next ' dl
> .datalabels.delete
> next srs
> next chtob
> next ws
> So it's a pain, but not insurmountable. Easier than searching for another program
> and learning how to make it do more than it's user interface can handle without
> special programming.
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> _______
> DrLostinExcel wrote:
> > WOW....
> > This is VERY VERY VERY BAD!!!!!!!!!!!!!!!!!!!!
> > I have HUGE presentations that I'm trying to generate automatically using
> > PowerPoint and Excel. I have between 40 and 90 graphs per presentation and
> > the number of items changes so how can I possibly know where to put the
> > labels?
> > What an INCREDIBLE lack of foresight...............
> > Time to look for an alternative to PowerPoint/Excel
> > Thanks Jon
> >
> > "Jon Peltier" wrote:
> >
> >
> >>Unfortunately, Excel does not trust its users to resize data labels, chart titles,
> >>or axis titles. If you need this level of control, you need to replace the data
> >>labels with text boxes.
> >>
> >>- Jon
> >>-------
> >>Jon Peltier, Microsoft Excel MVP
> >>Peltier Technical Services
> >>Tutorials and Custom Solutions
> >>
> >>_______
> >>
> >>DrLostinExcel wrote:
> >>
> >>
> >>>How do I change the size of a data label in a pie chart? I am getting
> >>>unusable wrapping of text when I have plently of room if I could only resize
> >>>the label box. All I've been able to do is move the label.
> >>>
> >>>Thanks,
> >>>
> >>>DLIE
> >>
> >>

I have Office XP Professional 2002. When using 'forms' tool batr I try to
change the size of the actual check box via format control and nothing
happens - only the bigger "defined" area around it. Move and size with cell
also is not offered as an option (it remains shaded)

Spinners by contrast DO allow a % size change or mm size change or via cell

How can I change the actual check box in a similar way to Spinners?


Is it possible to change the size of a column but only for the first two rows. Rows A & B have a wide column which is then essentially locked.

The rest of the sheet has smaller columns...

I can change the size of the box around a check box, but not the size of the
check box itself.

Does anyone know how to change the size of the font in the formula bar, i've

hi, if you're using checkboxes on user forms, you will be aware that you cannot change the size of the checkbox (you can change the size of the accompanying text).

one way is to create a subform and change the zoom, see

i've got another workaround, which may be of help.

it uses the wingding symbol Alt+0252 and puts this in the appropriate box whenever you click on it.

With the attached workbook I've got a range T20:U91 that's called 'perils_check'. Whenever you click on one of the boxes in the range, it toggles the tickmark

Hit Alt+F11 to view the code.

There is something strange with a spreadsheet, which contain many charts (all represent different temperature sensors).
I've made a macro to change at once time the X-Axis range (=time axis) on all charts.

The 1st time it works without any problem but if I want to change a second time the range, then many charts will be also reduced (only the chart inside the chart frame is reduced), although the macro act only on the values of the axis (... .Axes(xlCategory).MinimumScale = ...)
Have anyone any ideas why this happen. Is there any possibility to lock the size of my chart in order that when I change something in the axis it changes only what I want?


I recently changed the colors in "Accessories" to a different scheme. When I
did this, it shrunk the size of the tabs in my Excel workbook to barely


In my VBA code, I am putting comments on some cells using the command "add comment". The comment is having default font size. How to change the font size to say 11 using VBA?. I want to know how to change the size of the comment box also.

Apprecaite your help.

in the older versions this was done by holding shift and clicking on all the
shapes you wanted to change. You would then right click on you mouse to
bring up the menu to "format object" and change the size there. This
feature is grayed out in 07.

Hi members,

I want to change the caption of checkbox with VBA, but there are some of checkbox.

So, it's a problem how to change the parameter in code as follows:

for i = 1 to 10
    checkbox(i).Caption = "AA"
next i
I appreciate anyone help me

I have inserted a check ox in my spreadsheet but I want it to appear larger than surrounding text. I can right click the box and grab & drag a corner to increase the size of the box but the size of the actual check box and the text remain the same. I'm sure there is a simple answer!

Can you change the number of characters for the footer in Excel?
It only holds 255.

Does anyone know how to change the appearance of an in-cell drop-down list in
Excel? I want bigger fonts!
The fonts are too small to read unless users zoom in which of course will
display a smaller part of the sheet. Even at 70% the entries in the list are
too small to read.
Surely, there must be some way of changing the size of the entries in the

I am having trouble with the width of my graphs. Didn't know how to change the size of them. Any help?

I need to change the size on a great many comments on a Worksheet. I find
that this code:

Selection.ShapeRange.ScaleHeight 1.6, msoFalse, msoScaleFromTopLeft

will change, but relative to the default size. I can't find the syntax to
change to Height and Width settings.

Also, how can I change the default size?

Thanks for any help.

Is there any way to increase the size of the checkbox - the box itself, not the font - for a checkbox created from the Controls Toolbar?

The default size is too small when you zoom the sheet to less than 100%.


I use the little filter arrows a lot in excel 2007 and they are cool because of all the extra options and because it lists all your data with a check box so you can select many many variable - it's great - and I know I can change the size of the box all those choices are in by just grabbing the size handle at the bottom right corner and pulling it.

I am CONSTANTLY grabbing that handle and pulling down so I can see more of the filter list in one view - it really helps with scrolling long lists:

Is there a way to change the default size so it is bigger or am I required to grab that little handle all the time? (I'm a keyboard type - speed!)

There must be a VB code object parameter buried in there somewhere that tells the box how big to be when you activate the down arrow? Anyone know how to get to it and can I change the default size of perhaps change it's behavior to autosize or somthing?

Thanks for the help

Hi there,

I have this code in a userform and get with it a picture in the same size as
the chartobject - to small. I want a much larger (fill the screen as much as
possible). I can easily solve it by changing size of the chartobject before
export to gif, but i dno't want to do that. I want to change the size of the
gif during or after importing it by LoadPicture.


Help = Forever happy


Dim ChartNum As Integer

Private Sub UserForm_Initialize()
Debug.Print "frmPPT initilize "
ChartNum = 1
End Sub

Private Sub UpdateChart()
Set CurrentChart = Blad102.ChartObjects(ChartNum).Chart

' Save chart as GIF
Fname = ThisWorkbook.Path & Application.PathSeparator & "temp.GIF"
CurrentChart.Export Filename:=Fname, FilterName:="GIF"

' Show the chart
Image1.Picture = LoadPicture(Fname)

End Sub

Please advise as to how I can change the cell dimensions so that each cell is the size of an a4 piece of paper i.e 21.0cm x 29.7 cm. I can't seem to convert from points to cm?

I put a progroess on an Excel worksheet, save the file and close Excel.
When I open the workbook again, I find the size of progress bar changed.