Change font within a checkbox

**UncleKevy** · 07-26-2016, 10:05 AM

I have 20 check boxes within a dialog frame. Fifteen of them have the font I want and the other 5 do not. I need to change these last five to match the others. When used in the VBA macro, they look fine on the screen, but on the tab with the frame, they do not. The properties of the check box only allow resizing, but not adjustments to the font.

**6StringJazzer** · 07-26-2016, 11:23 AM

Are your checkboxes on a worksheet, or on a UserForm?
Did you use ActiveX checkboxes, or Form checkboxes?

ActiveX checkboxes most definitely have a Font property. If you are instead using Form checkboxes on a worksheet, you can't change the font but if you are using all Form controls then they should all have the same font.

It might be helpful to attach your file to make it clearer what you have done.

**UncleKevy** · 07-26-2016, 04:15 PM

I figured I left out some critical information. I wrote this code years ago and I am out of practice, not to mention that it is probably inefficient. Anyway the dialog frame is in a worksheet tab and it should open to that tab in the attached file. All of the code is in the file, but I had to lop off some of the tabs to get it to meet the size restrictions.

Originally, I could not get the form to work properly as a user form (user error I am sure), so I had to stick with something that worked. As you can see the fonts are uniform across the tab, except for the last five, which I added a few months back. For some reason they are stuck on the Courier font.

**NoSparks** · 07-26-2016, 04:33 PM

Can't tell you why, but when I copy and paste an existing one the font stays the same.

**6StringJazzer** · 07-26-2016, 06:47 PM

I don't know why those five have a different font, but you can't change it. They are Form controls (one reason I use ActiveX). But you can simply delete them and create five new ones, which should match the other font.