Excel, enlarge checkboxes

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

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?

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.

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...

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.

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.

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)