Excel, enlarge checkboxes Solved

Question

Hello,

I am working with Excel 2003.

I would like to modify the size of the checkbox only; for now, I can change the size of the checkbox (the entire checkbox and the text area to describe it).

Is this possible?

Thank you in advance

Configuration: Excel 2003 - Windows XP - Internet Explorer 6.0

melanie1324 · Accepted Answer

Hello,

To do this, go to View, toolbar, Controls toolbox, on this toolbar, at the top left, you have a button that looks like a ruler, square, and pencil, and if you hover your mouse over it, it says design mode.
Click on it, reconfigure your combobox, and click on the same button again to deactivate design mode.

mkos · Answer

We agree, but once in creation mode, I can't change the size of the checkbox, which is in the checkbox.

In property mode (the button that looks like a little hand and a small sheet :)), there are width and height parameters, but it changes the size of the checkbox; I would like to change the size of the box in the checkbox... Is it possible?

melanie1324 · Answer

Hello,

I think I understand what’s happening, your checkbox needs to be nested within the checkbox.
What you’re doing is a silly test, but it might work.

Move your checkbox completely elsewhere. Did your checkbox move? If not, enlarge it and put the checkbox back where it was.

Let me know if it worked.

mkos · Answer

Everything is nested in a block... nothing can be done to dissociate them... it has always been like that with my checkboxes, even if I move them, resize them, copy them, paste them... I have never been able to change the size of the small square that gets checked... Even if I enlarge the checkbox, the small square inside does not change size...

melanie1324 · Answer

Hello,

Can you upload your file? I'll try to see if I can help you somehow.
Because like this, I'm overwhelmed, but with the file, I might be able to find a solution.
If you don't want to share your file, create a generic file that addresses your problem or explain to me how you made your checkboxes.

melanie1324 · Answer

Re,

Actually, I have a solution. It's not great, but it could work for you.
You go to tools, macros, visual basic.
You insert a sheet.
It's a form and you can configure it however you want. (white background, black text, no title, disable the red cross)
In this form, you can place a title and a checkbox. I can't test it because visual basic editor doesn't work on my machine. But it seems to me that by going through there, you can configure your checkbox, then just place it wherever you want.
Then, you click on the sheet where you want your checkbox to be.
At the top of the screen in code, you have general. If you expand it, you should have activate or on sheet activation.
You put this code:
sub checkbox ()
userform.show
end sub

I agree with you that it's not a great solution, but it gets around your problem.

Mike-31 · Answer

Hi,

This question has often been asked on many forums without, to my knowledge, a solution being provided. Perhaps one day Microsoft will make this manipulation easier.

To work around this issue, here's a small tip that is worth what it is: the text box from the Visual Basic control toolbar.

Draw a small text box, double-click on it to open the properties, select Font and increase the size to 20 or more, you can also make it bold, then still in the properties, select TextAlign and choose center.

Paste this code into Visual Basic:

Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If TextBox1 = "X" Then
TextBox1 = ""
ElseIf TextBox1 = "" Then TextBox2 = "X"
End If
End Sub

Go back to the Excel sheet and disable design mode.

Click on the box; if it is empty, an X appears; if there is an X, it empties like a checkbox. The code remains to be written that, if there is an X, we do ...... otherwise ...... the X can be replaced by another symbol.

If you can't manage it, I'll make a little montage for you.
A+
Mike-31

A problem without a solution is a problem poorly posed (Einstein)

mkos · Answer

Ah interesting technique, I tried it but it doesn't really suit me... If there's no way to do it with Microsoft, I guess I’ll leave my box a bit small, too bad...

Thank you

I'm marking the problem as resolved, even if only Microsoft could apparently change this, but you did your best!! :)

Ciao

Excel, enlarge checkboxes

8 réponses

Texture issues in enshrouded

Big fish games are they worth it?

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress